title: Querying a string from int column?
body: <p>I have a table:</p>
  
  <pre><code>CREATE TABLE `ids` (
      id int(11) not null auto_increment,
      PRIMARY KEY (id)
  );
  </code></pre>
  
  <p>It contains some IDs: 111, 112, 113, 114 etc.</p>
  
  <p>I made a query: </p>
  
  <pre><code>SELECT * FROM `ids` WHERE id = '112abcdefg'
  </code></pre>
  
  <p>I expected nothing but I've got a result, a row with ID of 112. Seems that MySQL quietly converted my string to integer and then compared it against column values.</p>
  
  <p>How can I change the query so that querying the same string from <code>id</code> column will give no results as I expect? Is there a strict comparison modifier in MySQL?</p>