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".
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/[EMAIL PROTECTED]
