Check email syntax

Check email syntax using regular expression.

Last updated: 19 September 2016

Warning: Review and test in a non-production environment before running.

Back to results

SELECT distinct email,
regexp_substr(email,'[a-zA-Z0-9._%-]+@[a-zA-Z0-9._%-]+\.[a-zA-Z]{2,4}') email_checked
FROM table_name
WHERE id = 111111111
and regexp_like (email,'[a-zA-Z0-9._%-]+@[a-zA-Z0-9._%-]+\.[a-zA-Z]{2,4}');