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;