title: Mysql query not returning correct value when date field in where condition
body: <p>In my <code>sales</code> table the <code>sale_date</code> field is in <code>date</code> format</p>
  
  <p>When I run the query,</p>
  
  <pre><code>SELECT * FROM `sales` WHERE sale_date=2014-10-01;
  </code></pre>
  
  <p>Return no result. Actually the <code>sale_date</code> field contains the value <strong>2014-10-01</strong>.</p>