*Shrug*
Don't have time to test at the moment... That was taken from Chapter 9.3.4.7
of the MySQL manual....
http://www.mysql.com/doc/P/a/Pattern_matching.html
Prior to MySQL Version 3.23.4, REGEXP is case sensitive, and the previous
query will return no rows. To match either lowercase or uppercase `b', use
this query instead:
mysql> SELECT * FROM pet WHERE name REGEXP "^[bB]";
Was worth a try :)
James.
"Martín Marqués" <[EMAIL PROTECTED]> wrote in message
01052312020905.03109@bugs">news:01052312020905.03109@bugs...
> On Mié 23 May 2001 17:56, you wrote:
> > Hey try this, though there are probably better ways,
> >
> > "SELECT * FROM foo WHERE name REGEXP '^[PHP]'";
>
> This is not SQL compatible. This would be a correct SQL statement:
>
> SELECT * FROM foo WHERE name LIKE "[PHP]%"
>
> Saludos... :-)
>
> --
> Cualquiera administra un NT.
> Ese es el problema, que cualquiera administre.
> -----------------------------------------------------------------
> Martin Marques | [EMAIL PROTECTED]
> Programador, Administrador | Centro de Telematica
> Universidad Nacional
> del Litoral
> -----------------------------------------------------------------
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
