title: All MySQL records from yesterday
body: <p>What is the most efficient way to get all records with a datetime field that falls somewhere between yesterday at <code>00:00:00</code> and yesterday at <code>23:59:59</code>?</p>
  
  <p>Table:</p>
  
  <pre><code>id    created_at
  1     2016-01-19 20:03:00
  2     2016-01-19 11:12:05
  3     2016-01-20 03:04:01
  </code></pre>
  
  <p>Suppose yesterday was 2016-01-19, then in this case all I'd want to return is rows 1 and 2.</p>