List:General Discussion« Previous MessageNext Message »
From:Leandro Guimarães Faria Corcete DUTRA Date:November 8 2006 6:20pm
Subject:Re: Regular expression not working as expected (documented)?
View as plain text  
Em Qua, 2006-11-08 às 19:16 +0100, Christian Hammers escreveu:
> 
> 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".

	I got that from cname.h, mentioned in the MySQL regexp documentation.


> 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.

	Hm, but I do need to take into account the period.

	Also, do you mean the - at the beginning will make all following
characters be treated literally?


-- 
+55 (11) 5685 2219               xmpp:leandrod@stripped
+55 (11) 9406 7191          Yahoo!: ymsgr:sendIM?lgcdutra
+55 (11) 5686 9607  ICQ/AIM: aim:GoIM?screenname=61287803
        MSN: msnim:chat?contact=leandro@stripped

Thread
Regular expression not working as expected (documented)?Leandro Guimarães Faria Corcete DUTRA8 Nov
  • Re: Regular expression not working as expected (documented)?Christian Hammers8 Nov
    • Re: Regular expression not working as expected (documented)?Leandro Guimarães Faria Corcete DUTRA8 Nov
      • Re: Regular expression not working as expected (documented)?Dan Nelson8 Nov
        • Re: Regular expression not working as expected (documented)?Leandro Guimarães Faria Corcete DUTRA8 Nov
      • Re: Regular expression not working as expected (documented)?Christian Hammers8 Nov
    • RE: Regular expression not working as expected (documented)?Jerry Schwartz8 Nov