Dental Articles - Edmonton

MySQL find duplicates

Posted by negraru on Tue, 13 Jun 2017

MySQL query to find duplicates and to select all but ignore duplicates

Find duplicates:

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

Select all but ignore duplicates:

SELECT email FROM directory_list WHERE email LIKE '%@%' GROUP BY email ASC;

Designer Edmonton