[SOLVED] help with mysql query

[syntax101]

how do i select a data from the database without repeating the value to be stored

 

 

ex

 

JOBORDER    NAME   

1                A

1                A

1                A

2                A

3                B

4                C

2                A

 

i want to select the JOBORDER DATA 1,2,3,4 without repeat the numbers just like above

 

result

JOBORDER

1

2

3

4

[rajivgonsalves]

use the DISTINCT keyword

 

select DISTINCT fieldnames from tablename;

[syntax101]

thanx a lot, i used group by but its more simplier if i use distinct

[fenway]

thanx a lot, i used group by but its more simplier if i use distinct

And much better... don't ever use DISTINCT as a modifier to select, it's never what you want.

[syntax101]

thanx a lot, i used group by but its more simplier if i use distinct

And much better... don't ever use DISTINCT as a modifier to select, it's never what you want.

 

what do you mean by never to use distinct as a modifier to select.

 

sorry for that because i cannot understand it. im still a newbie

[fenway]

Just stick with group by and you'll always be fine... I'm actually going to be posting a sticky with a bunch of these types of things soon.