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;
![]()
Search · Sitemap · Contact · Account Center
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;
![]()