Re: [PHP-DB] Return 1 instance of each unique record?

[Adam Williams]

use GROUP BY field

                        Adam

On Fri, 6 Dec 2002, Doug Coning wrote:

> Hi everyone:
>
> How do I get MySQL to summarize a query so that I receive only 1 instance
> per similar record.  I.E. if you have 10 records with name "Smith" and 5
> records with "Barney, etc, that it would return 2 records instead of 15.
>
> Thanks!
>
> Doug Coning
>
>
>
>
>


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