Find duplicate values in mysql

10/15/2013 - 1:20 AM

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

Cacher is the code snippet organizer for pro developers