title: MySQL select from INT column
body: <p>I was doing some system testing and expecting empty results from MySQL(5.7.21) but got surprised to get results.</p>
  
  <p>My transactions table looks like this:</p>
  
  <pre><code>Column        Data type
  ----------------------------
  id           | INT
  fullnames    | VARCHAR(40)
  ---------------------------
  </code></pre>
  
  <p>And I have some records </p>
  
  <pre><code>--------------------------------
  id           | fullnames
  --------------------------------
  20           | Mutinda Boniface
  21           | Boniface M
  22           | Some-other Guy
  -------------------------------
  </code></pre>
  
  <p>My sample queries:</p>
  
  <pre><code>select * from transactions where id = "20"; -- gives me 1 record which is fine
  select * from transactions where id = 20; -- gives me 1 record - FINE as well
  </code></pre>
  
  <p>Now it gets interesting when I try with these:</p>
  
  <pre><code>select * from transactions where id = "20xxx"; -- gives me 1 record - what is happening here?
  </code></pre>
  
  <p>What does MySQL do here??</p>