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
- Route OpenVPN Connections Through Floating IP
- How to Configure a Floating IP in a VPS (Hetzner)
- Set OpenVPN to Listed on a Specific IP Address
- Bash Trim Leading and Trailing Whitespace from a String
- Bash Get Name of Ethernet Network Interface
- VPN Providers with Dedicated Static IP Address
- OpenVPN Iptables Rules
- WireGuard VPN Iptables Rules
Updated Posts
- AMD Chipsets & Graphics Card Drivers for Windows 7, 8, 10
- AMD Radeon 7400 Drivers for Windows 10
- How to pass custom command-line parameters in InnoSetup
- Add Desktop shortcut for all Windows PC users
- Programmatically create desktop icon with InnoSetup
- GeneratePress - a Lightweight WordPress Theme 2021
- InnoSetup disable DesktopIcon via command-line
- Use cURL to authenticate with JWT Bearer tokens