Re: I know this has been asked before, but....
| From: | Ron Brogden | Date: | Wed, 11 Apr 2001 23:08:08 +0000 |
| Subject: | Re: I know this has been asked before, but.... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8505@lists.php.net to get a copy of this message | ||
At 03:38 PM 4/11/2001 -0700, SHAWN wrote:
What's the SELECT statment I want to use to find duplicate entries in a specific field?SELECT column_name, count(*) AS doubles FROM some_table HAVING doubles > 1 GROUP BY colname This should grab all instances where there are multiple instances of "column_name" with the same value. Cheers, Ron -----------------------------------------------------------------------------
Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free: 1 800 331-3055 Victoria, B.C. Fax: 250 383-6698 V8W 2L1 E-Mail: support@islandnet.com Canada WWW: http://www.islandnet.com/-----------------------------------------------------------------------------