Hi !
I'm working on a regex to "validate" emails stored in a table.
I'll try other regex from php tips or javascripts tips, but the exact
syntaxe of regex in mysql are differents and nothing work fine... And
I'm not very good with regex :\
I find this :
SELECT email FROM mailing WHERE email
REGEXP '^([a-zA-Z0-9])+([\.a-zA-Z0-9_-])*@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+';
But some of "false" mails are accepted, like "[EMAIL PROTECTED]".
Can you help me ?
Regards
--
*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
Richard CARLIER http://www.rcarlier.net
(o_ - Votre association et Internet (mai 2002, VMP, 2-7440-6013-5)
//\ - Profession Webmaster (nov. 2000, Les Echos, 2-84211-112-5)
V_/_ - Cocktails, boissons (http://www.atontour.com)
*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
