Non-repeating results SQL statement
Posted on 2003-11-05
I know, busy week for me on these boards right? Hehe...anyways.
WHERE pov !='' AND pov!='some' AND pov!='some2' AND pov!='some3'
ORDER BY pov ASC
And it gives me the results I want...well almost (hence the question).
Let's say that in my data there are multiple entries of the same type, so lets say there are 6 values for 'test'. How do I tell MySQL only to give me the unique ones? So instead of returning 6 results for 'test' it will return 1 unique result for 'test'. I need this because this will become a select box and it will look wierd if 'test' repeats itself 6 times.
Thanks in advance.