Re: How to select rows from Mysql with case senstive ??

*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" <martin@bugs.unl.edu.ar> wrote in message 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 | mmarques@unl.edu.ar > Programador, Administrador | Centro de Telematica > Universidad Nacional > del Litoral > ----------------------------------------------------------------- > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >