Re: REGEXP emal address query

2002-12-14 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Richard -- ...and then Richard Baskett said... % % 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

Re: REGEXP emal address query

2002-12-10 Thread Richard Baskett
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 a