Is there an easy way to select the inverse of a regexp statement? I have the following statement that selects valid email addresses:
SELECT email FROM applications WHERE email regexp '^([0-9,a-z,A-Z]+)([.,_]([0-9,a-z,A-Z]+))*[@]([0-9,a-z,A-Z]+)([.,_,-]([0-9,a-z,A-Z]+))*[.]([0-9,a-z,A-Z]){2}([0-9,a-z,A-Z])?$' ORDER BY email";
I want to be able to select the email address that DO NOT meet the above expression...
thanks!
Brooks
SELECT email FROM applications WHERE email regexp '^([0-9,a-z,A-Z]+)([.,_]([0-9,a-z,A-Z]+))*[@]([0-9,a-z,A-Z]+)([.,_,-]([0-9,a-z,A-Z]+))*[.]([0-9,a-z,A-Z]){2}([0-9,a-z,A-Z])?$' ORDER BY email";
I want to be able to select the email address that DO NOT meet the above expression...
thanks!
Brooks