title: If MYSQL is case insensitive,How does it works for the Password field in Login?
body: <p>I was wondering in case of normal select operation the search is case insenesitive.
  So <code>SELECT * FROM tbl WHERE name = aBc</code> will also consider name with values ABC,abc,abC etc</p>
  
  <p>but in case of login function we just do 
  <code>SELECT * FROM tbl WHERE password = aBc</code>
  will be case sensitive and only consider password with aBc value.</p>
  
  <p>How does this happens?I didnt found anything about this in my searches.</p>
  
  <p>Please care to explain.</p>
  
  <p>Thanx All.</p>