According to the documentation, [.period.] should match but so should [...] (if I read it right).
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: Christian Hammers [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 08, 2006 1:16 PM > To: Leandro Guimarães Faria Corcete DUTRA > Cc: mysql@lists.mysql.com > Subject: Re: Regular expression not working as expected (documented)? > > > > On 2006-11-08 Leandro Guimarães Faria Corcete DUTRA wrote: > > u.login REGEXP > '^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*' > ... > > But I get, among otherss, a string beginning with 'walt' > (several, in fact). > > Probably MySQL don't know about this "[.period.]" thing and > just takes the "." in it > as "any char", e.g. your "t" from "walt". > > Try '^wa[bhkl][-_acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*', > if there is a "-" at the > beginning of a character class it is usually threaten > literally as it makes no sense > as "from..to" separator in those cases. > > bye, > > -christian- > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
