title: MySQL automatic string to integer casting in where clause?
body: <p>I am not new to MySQL but a strange situation happened in my code today coincidently which got me surprised. Can someone explain why this gives me identical results?</p>
  
  <pre><code>SELECT * FROM `products` WHERE id = 12
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT * FROM `products` WHERE id = '12ABC'
  </code></pre>
  
  <p>In both cases I get the same result with the same record being selected. I would expect that second one would return me nothing?! My ID field is int(11) unsigned with auto_increment flag turned on.</p>