MySQL Find Duplicate Data in a Column Computers and Networking May 142014 Find duplicate data in a column. SELECT column1, COUNT(*) c FROM table GROUP BY column1 HAVING c > 1; Source