Konstantinos Polychronis in Programming | 2012/01/14 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; Konstantinos Polychronis Published 2012/01/14