Articles & Code Snippets


MySQL find duplicates

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;
web


Archives

Just feel like saying Hi?

  1 (903) NEGRARU phone
  email