Case-sensitive search in MySQL database

[nasio]

Hello,

I have a database where I store my members username and password. I've noticed that searching the database for

$username='MyUsername' and $password='MyPassword'

will give the same results as searching for

$username='myusername' and $password='mypassword'

I don't mind the username being case-insensitive, but I need the password search to be case-sensitive! Does anyone know how to accomplish this?

[freddydoesphp]

I think for that you probably will have to retrieve the data and then validate the password using php so you can do a case-sensitive comparison.

[Ed Sullivan]

Actually you can force MySQL to think the data is binary, hence being case sensitive, using the BINARY cast operator. The following should work:

BINARY username='MyUsername' and BINARY password='MyPassword'

[Umair.ms]

An alternative method is to retrieve username and password and compare them using a 'strcmp' statement.