title: MySQL automatically cast/convert a string to a number?
body: <p>Does MySQL automatically casting\converting the string to numeric value?<br>
  How does that conversion works?</p>
  
  <ul>
  <li>'1234'=1234 ?</li>
  <li>'1abc' = 1 ?</li>
  <li>'text' = 1 ?</li>
  </ul>
  
  <p>Given that <code>units.id</code> is of bigint type, how this query will be interpreted? </p>
  
  <pre><code>SELECT table.* 
  FROM table 
  WHERE id='text'
  </code></pre>