[PHP] How to select rows from Mysql with case senstive ??

[Bass¨Ð¦õªv]

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]