Posted on May 20, 2017 at 10:23 am

Fastest ways to find duplicate records in MySQL.

If name is the column you want to find duplicates in:

SELECT col1 FROM table GROUP BY col1 HAVING count(*) > 1;

Is also possible to support multiple columns, like this:

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

Get the IDs of the duplicate rows with GROUP_CONCAT:

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

Other Posts

• Bash Get the size of a file
• Crontab requires escaping any % signs
• Bash Check folder size Linux
• Bash remove the first line of a large file
• ERROR 1114 (HY000): The table 'site' is fullage done
• Get Linux Server Unique Machine ID
• Linux make files accessible only by root
• Bash Autologin with MySQL MariaDB server

Updated Posts

• Backup MySQL datadir without Mysqldump
• Import MySQL Database from CommandLine
• Delphi 10 Berlin System.Hash MD5 SHA1 SHA2 Hash
• Standard ISO paper sizes, DPI and images size
• Download Google Chrome Full Standalone Offline Installer
• PHP cURL curl_getinfo() Output
• PHP cURL Get Redirect URL as Variable
• Upload a File via POST with cURL and PHP 7