Thanks everyone... I find my problem often time is terminology. I am a FileMaker database developer and know the terminology of that database. I love MySQL, especially it's speed, but find crossing over sometimes difficult because the terminology is different and so I will do a search at MySQL on the terminology I'm used to, which in this case was "summarize by"and found nothing. Then I have to bother you guys to find out what the correct verbage is. Thank you for your patience! Doug ----- Original Message ----- From: "Adam Williams" <awilliam@mdah.state.ms.us> To: "Doug Coning" <lists@coning.com> Cc: <php-db@lists.php.net> Sent: Friday, December 06, 2002 2:27 PM Subject: Re: Return 1 instance of each unique record? > 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
