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]
