title: Grab where CURDATE() and the day before with MySQL
body: <pre><code>offers.date = CURDATE() 
  </code></pre>
  
  <p>I what I currently have.</p>
  
  <p>It grabs offers for today, but I also would like to grab the orders for yesterday.</p>
  
  <p>How can I do this, without specifying the yesterday's date?</p>