Re: Regular expression not working as expected (documented)?

2006-11-08 Thread Christian Hammers
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

Re: Regular expression not working as expected (documented)?

2006-11-08 Thread Leandro Guimarães Faria Corcete DUTRA
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

Re: Regular expression not working as expected (documented)?

2006-11-08 Thread Dan Nelson
In the last episode (Nov 08), Leandro Guimar~aes Faria Corcete DUTRA said: Em Qua, 2006-11-08 às 19:16 +0100, Christian Hammers escreveu: On 2006-11-08 Leandro Guimar~aes Faria Corcete DUTRA wrote: u.login REGEXP

RE: Regular expression not working as expected (documented)?

2006-11-08 Thread Jerry Schwartz
:[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

Re: Regular expression not working as expected (documented)?

2006-11-08 Thread Christian Hammers
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.]

Re: Regular expression not working as expected (documented)?

2006-11-08 Thread Leandro Guimarães Faria Corcete DUTRA
Em Qua, 2006-11-08 às 12:53 -0600, Dan Nelson escreveu: . within brackets is treated literally anyway, so there's no need to use [.period.]. OK, I had taken the effects of - as being the effects of . REGEXP BINARY '^wa[bhkl][-_.acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*' It