I was wondering in case of normal select operation the search is case insenesitive.
So `SELECT * FROM tbl WHERE name = aBc` will also consider name with values ABC,abc,abC etc

but in case of login function we just do 
`SELECT * FROM tbl WHERE password = aBc`
will be case sensitive and only consider password with aBc value.

How does this happens?I didnt found anything about this in my searches.

Please care to explain.

Thanx All.