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: [EMAIL PROTECTED] Canada WWW: http://www.islandnet.com/ ----------------------------------------------------------------------------- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
