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
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