Case sensitive username and password

[vreddy]

Hi folks,

I have a feeling this problem has a really simple answer. I want to authenticate a user based on "username" and "password", but I want the query to be case sensitive. What is the best way to do this. Right now, this query seems to be case insensitive and returns true for any case (upper/lower) of the username or password.

$query = "SELECT * FROM vaultusers WHERE username='$username' AND password='$password'";

[ahundiak]

Yet another wonderful mysql 'feature'.
http://www.mysql.com/documentation/mysql/bychapter/manual_Functions.html#Case_Sensitivity_Operators