Regular expression not working as expected (documented)?

[Leandro Guimarães Faria Corcete DUTRA]

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].*'
;

[EMAIL PROTECTED](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:[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]