title: Mysql returning rows with zero (0) column data in WHERE clause
body: <p>I have a simple query for my table:</p>
  
  <pre><code>SELECT * from delivery_receipts WHERE siid='';
  </code></pre>
  
  <p>This table's unique key is drid, (irrelevant for this question)..
  The targeted column (<code>siid</code>) is an <code>int(11)</code> field, non index and non unique... </p>
  
  <p>Anyway my problem is that, when I run this, mysql returns ALL ROWS that has:</p>
  
  <pre><code>SELECT drid,siid from delivery_receipts WHERE siid='0'
  </code></pre>
  
  <p>But of course if I search with the <code>siid</code> specified, only the rows w/ that <code>siid</code> match comes up....</p>
  
  <p>So it seems my table is returning a match on all rows that has "0" when searching for ''</p>