SQL query to find all email addresses before @ that have more than three periods

[Brent W]

Would like to be able to run an sql query against my databases where the email address has more than three periods before the @ part of the email address.

 

[HWS]

SELECT email from xf_user WHERE email LIKE '%.%.%.%@%'

will return all emails with 3 or more dots before the @.
(edited missing %)

 

[Brent W]

SELECT email from xf_user WHERE email LIKE '%.%.%.%@'

Doesn't work against this email: k.i.d.i.e.mu@gmail.com

 

[HWS]

Doesn't work against this email: k.i.d.i.e.mu@gmail.com

Ah, sorry, should be:

SELECT email from xf_user WHERE email LIKE '%.%.%.%@%'

 

[Brent W]

Ah, sorry, should be:

SELECT email from xf_user WHERE email LIKE '%.%.%.%@%'

Thanks that worked.