Re: [PHP-DB] I know this has been asked before, but....
At 04:08 PM 4/11/2001 -0700, Ron Brogden wrote: >SELECT column_name, count(*) AS doubles FROM some_table HAVING doubles > 1 >GROUP BY colname Ack, that GROUP BY should be "column_name" (was trying to make it more obvious and missed the last reference). Cheers - 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]
Re: [PHP-DB] I know this has been asked before, but....
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]
[PHP-DB] I know this has been asked before, but....
I can't find the answer to this, I know it's easy. What's the SELECT statment I want to use to find duplicate entries in a specific field? Thanks in Advance! Shawn Sellars