Find Duplicate MySQL Records

by Kyle on · Posted in MySQL

SELECT email, count(email) AS total FROM `tbl_mailing_list` GROUP BY email HAVING total > 1 ORDER BY total;

Save. Share. Submit.

Rate Snippet

Related Snips

Hide Sidebar