MySQL Knowledge Base

How to Find Duplicate Values in MySQL

Syntax

SELECT 
    email, 
    COUNT(email)
FROM
    contacts
GROUP BY email
HAVING COUNT(email) > 1;