[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

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