Select Inverse of a Regexp?

wxdqz

New Member
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
 
Back
Top