find duplicates mysql column

The solution for this is noted below

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

Try other methods by searching on the site. That is if this doesn’t work