Hi,
> dog
> fooID int
> size int
> id int
>
> dog
> fooID size id
> 1 2 1
> 2 5 2
> 1 5 3
>
> if i do a query
> select * from dog where fooID='1';
>
> i get
> 1,2,1
> 1,5,3
>
Try,
select * from dog where fooID=1 group by fooID;
- which retrieves the first instance;
resulting in,
1,2,1
Thanks
ViSolve DB Team
----- Original Message -----
From: "bruce" <bedouglas@stripped>
To: <mysql@stripped>
Sent: Thursday, January 04, 2007 6:07 AM
Subject: mysql question regarding distinct/group by...
> hi...
>
> i've asked something similar before.. but it appears something is going
> wrong... so, back to basics...
>
> i have the following test tbl.
>
> dog
> fooID int
> size int
> id int
>
> dog
> fooID size id
> 1 2 1
> 2 5 2
> 1 5 3
>
> if i do a query
> select * from dog where fooID='1';
>
> i get
> 1,2,1
> 1,5,3
>
> how can i do a distinct/group by select such that if i do a select on
> fooID=1, i'll only get '1,2,1', or '1,5,3', meaning that i don't get both
> of
> the items where fooId=1.
>
> thanks...
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
