find duplicates mysql column
snippet in sql

find duplicates mysql column

user4787

SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;