All MySQL records from yesterday : <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>
