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

Brent W

Well-known member
#1
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

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

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