Find duplicate entries in a table

Try this:
SELECT * 
FROM table_name
GROUP BY target_field
HAVING COUNT( target_field ) >1

Posted in: MYSQL