Re: Creating A Unique List With Table Query
| From: | Per Jessen | Date: | Tue, 10 Feb 2009 19:45:49 +0000 |
| Subject: | Re: Creating A Unique List With Table Query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-288081@lists.php.net to get a copy of this message | ||
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)