Ok finally found the answer after many hours of searching :) Here is the
MySQL query that works great!
SELECT * FROM table_name
WHERE Email NOT
REGEXP "^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}"
Thanks to all that replied!
Rick
"Keep away from people who belittle your ambitions. Small people always do
that, but the really great, make you feel that you too can become great." -
Mark Twain
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
