Re[2]: Regex and email

2003-09-01 Thread Richard Carlier
Bonjour Matthew ! MS> Not sure about php syntax, but check out the perl module (in CPAN) MS> Email::Valid. I'm not searching the PHP syntax, but the SQL syntax... :) A + -- ** Richard CARLIER htt

RE: Regex and email

2003-09-01 Thread Matthew Smith
))[^\\\x80-\x ff\n\015()]*)*\)[\040\t]*)*(?:\.[\040\t]*(?:\([^\\\x80-\xff\n\015()]*( ?:(?:\\[^\x80-\xff]|\([^\\\x80-\xff\n\015()]*(?:\\[^\x80-\xff][^\\\x80 -\xff\n\015()]*)*\))[^\\\x80-\xff\n\015()]*)*\)[\040\t]*)*(?:[^(\040)< >@,;:".\\\[\]\000-\037\x80-\xff]+(?![^(\040)<>@,;

Regex and email

2003-09-01 Thread Richard Carlier
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 emai