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

Brent W

Well-known member
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.


Well-known member
SELECT email from xf_user WHERE email LIKE '%.%.%.%@%'

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