Home Code Snips Find Duplicate MySQL Records SELECT email, COUNT(email) AS total FROM `tbl_mailing_list` GROUP BY email HAVING total > 1 ORDER BY total;