MySQL Lists: mysql: the rest of Latin1 in a regular expression

List:	General Discussion	« Previous Message Next Message »
From:	(Hal	Date:	January 26 2012 12:10am
Subject:	the rest of Latin1 in a regular expression
View as plain text

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?

Thread
• the rest of Latin1 in a regular expression	hsv	26 Jan