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
