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 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".
I got that from cname.h, mentioned in the MySQL regexp documentation.
> 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.
Hm, but I do need to take into account the period.
Also, do you mean the - at the beginning will make all following
characters be treated literally?
--
+55 (11) 5685 2219 xmpp:[EMAIL PROTECTED]
+55 (11) 9406 7191 Yahoo!: ymsgr:sendIM?lgcdutra
+55 (11) 5686 9607 ICQ/AIM: aim:GoIM?screenname=61287803
MSN: msnim:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
