Use the following SQL statement for finding duplicates in a table. I think this should work
for any relational database, not only MySQL.
SELECT col_name, COUNT(col_name) AS num
GROUP BY col_name
HAVING (COUNT(col_name) > 1);
This tip was posted as an answer to question: How do I find duplicate records in a table?