Here is an example for checking for duplicate emails
SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING ( COUNT(email) > 1 )
Mysql - check for duplicates
- By Heather Mello
- Apr 5, 2016
Here is an example for checking for duplicate emails
SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING ( COUNT(email) > 1 )