A nice simple query to find duplicate rows in MySQL: SELECT COLUMN_NAME, COUNT(*) c FROM TABLE GROUP BY COLUMN_NAME HAVING c > 1; Credit to the Tin Man