Re: Multiple same values only wanting one

[Pete Morganic <pete@daffodil.uk.com>]

select distinct(myCol) from table

Ron Allen wrote:
> How do I select * from a table, but I do not want it to return the same
> value if two fields are the same.  Example
>
> test
> test
> test
> test
> new
> new
> new
>
> Results that I want are just
>
> test
> new
>
> Any suggestions?


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php