Tag Archives: Regexp

Mysql: find wrong emailadres

Posted by westworld on December 11, 2008 No comments

SELECT Email FROM Emails where Email not REGEXP ‘^[A-Z0-9._%+-]+@[A-Z0-9.-]+.[A-Z]{2,4}$’ and Email != “”