title: Mysql Like + Wild Card vs Equals Operator
body: <p>I recently just fixed a bug in some of my code and was hoping someone could explain to me why the bug occurred.</p>
  
  <p>I had a query like this:</p>
  
  <pre><code>SELECT * FROM my_table WHERE my_field=13
  </code></pre>
  
  <p>Unexpectedly, this was returning rows where <code>my_field</code> was equal to either <code>13</code> or <code>13a</code>. The fix was simple, I changed the query to:</p>
  
  <pre><code>SELECT * FROM my_table WHERE my_field='13'
  </code></pre>
  
  <p>My question is, is this supposed to be the case? I've always thought that to return a similar field, you would use something like:</p>
  
  <pre><code>SELECT * FROM my_table WHERE my_field LIKE '13%'
  </code></pre>
  
  <p>What is the difference between LIKE + a Wild Card vs an equals operator with no quotes?</p>