Mysql REGEX to update a field based upon a valid email
UPDATE USERS SET IS_VALID_EMAIL='Y' WHERE EMAIL regexp '^[a-zA-Z0-9._-]+@([a-zA-Z0-9._-]+\.)+([a-zA-Z0-9_-]){2,3}$'
or to not match a@a..com
^([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)$
posted by Scales and Pom 12:46 PM