This is a decent approximation to matching one "word" in an email-address, separated by dots, and, of course, the commercial multiplication sign "@"

[!#-'*+/-9=?A-Z^-~-]+

but I want to add the Latin1 graphics to it. Is this best done by concatenation,

'[-!#-''*+/-9=?A-Z^-~' || x'A0' || '-' || x'FF' || ']+'

or is there something neater?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql