revDAVE wrote: > Newbie question > > Hi Folks, > > I would like to be able to query a table, and return only the unique > values from a particular field. For example: to get all contents from > the category field from the contacts table: > > Query = .... > > SELECT Category FROM contacts > > But this will produce many duplicates. > > Question : How do I filter the query to only produce unique values?
SELECT DISTINCT Category FROM contacts -- Per Jessen, Zürich (1.6°C) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
