How to select rows from Mysql with case senstive ??
| From: | Bass���v | Date: | Wed, 23 May 2001 13:54:50 +0000 |
| Subject: | How to select rows from Mysql with case senstive ?? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-54056@lists.php.net to get a copy of this message | ||
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