Case sensitive queries

I am storing user names and passwords in a mysql database. The problem is when I perform the following query:

Select * FROM sometable WHERE name='name' AND password='pass'

It is not case sensitive, is there anyway for me to force this to be case sensitive?

Any help would be appreciated, thank you.

You need to set the columns as BINARY or use the BINARY cast then the searches will be case sensitive.

Select * FROM sometable WHERE name = BINARY 'name' AND password = BINARY 'pass';

Hope this helps 😉

Thanks, I'll try it asap.

It works, excellent. Thank you very much.