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]