• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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 %)