Re: How to select rows from Mysql with case senstive ??
| From: | Martín Marqués | Date: | Wed, 23 May 2001 09:02:09 +0000 |
| Subject: | Re: How to select rows from Mysql with case senstive ?? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-54080@lists.php.net to get a copy of this message | ||
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
-----------------------------------------------------------------