SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;
https://stackoverflow.com/questions/688549/finding-duplicate-values-in-mysql
SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;
https://stackoverflow.com/questions/688549/finding-duplicate-values-in-mysql