Skip to main content

Identifying duplicate values in a MySQL database:

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

(pretty simple but I always forget)