Search for email addresses that are used for more than one account

[DF031]

Good morning all,

Is there a way to search for email addresses that are used for more than one account ?

Either a built-in option, a mod, or using phpmyadmin

Thanks in advance for your help

[ozzy47]

You could run this query in the ACP to see if there are any.

SELECT email, COUNT(email) AS Duplicates FROM user GROUP BY email HAVING ( COUNT(email) > 1 )

Then let me know the output of that.

[DF031]

Thanks !

Works like a charm.

[ozzy47]

Glad that worked for you. :)