The following query can be used to count duplicated records in MySQL: SELECT count(*) AS duplicate_count FROM ( SELECT column_name FROM table GROUP BY column_name HAVING COUNT(column_name) > 1 ) AS t