List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:November 8 2006 6:56pm
Subject:RE: Regular expression not working as expected (documented)?
View as plain text  
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:ch@stripped]
> Sent: Wednesday, November 08, 2006 1:16 PM
> Cc: mysql@stripped
> Subject: Re: Regular expression not working as expected (documented)?
>
>
>
> >         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/mysql?unsub=1
>
>



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