List:General Discussion« Previous MessageNext Message »
From:Leandro Guimarães Faria Corcete DUTRA Date:November 8 2006 5:56pm
Subject: Regular expression not working as expected (documented)?
View as plain text  
I must have understood something wrong in the regexps docs:

 SELECT
        login
   FROM
        orolixMain.Users        u
  WHERE
        u.login REGEXP '^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*'
;

ldutra@tutatis.(none)> \. usr/src/oro/qry/phshr.sql
+-------------------+
| login             |
+-------------------+
[…]
| walt[…]       | 
[…]
+-------------------+
49 rows in set (4.46 sec)


   	The regexp I used was to return strings began by wa, followed by [bhkl],
and then by one to five characters in the [_[.period.]-acegmnopqrsuvwxyz] list.
But I get, among otherss, a string beginning with 'walt' (several, in fact).

      	Ideas?

-- 
Leandro Guimarães Faria Corcete DUTRA     +55 (11) 9406 7191 (cel)
Administrador de (Bases de) Dados         +55 (11) 2122 0302 (com)
http://br.geocities.com./lgcdutra/        +55 (11) 5685 2219 (res)
BRASIL                            mailto: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