Try
SELECT * FROM foo WHERE strcmp('PHP', name) = 0;
> -----Original Message-----
> From: Bass¨Ð¦õªv [mailto:[EMAIL PROTECTED]]
> Sent: quarta-feira, 23 de Maio de 2001 14:55
> To: [EMAIL PROTECTED]
> Subject: [PHP] How to select rows from Mysql with case senstive ??
>
>
> Hi ,
> By defualt , select rows from Mysql is case insenstive .
> For exmaple ,
> select * from foo where name = 'PHP'
> select * from foo where name = 'php'
> is the same
>
> how can i do a queny which
> select * from foo where name = 'PHP'
> is success
> but
> select * from foo where name = 'php'
> fail ??
>
> given that name = 'PHP' in the database
>
> thx
>
>
>
> --
> 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]
