Finding duplicate values in MySQL

There is an easy and quick way to find duplicate values in a MySQL table.
You can use this query:

SELECT *, COUNT(*) c FROM tablename GROUP BY searchablefield HAVING c > 1;
Share