Jul 27th, 2013
See: http://dev.mysql.com/doc/refman/5.0/en/group-by-extensions.html
Do a SELECT with a GROUP BY clause. Let's say name is the column you want to find duplicates in:
SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;