title: MySQL select yesterday's date
body: <p>If I have a date like this:</p>
  
  <pre><code>'2013-03-25'
  </code></pre>
  
  <p>And I want to write a MySQL query with <code>WHERE</code> is "yesterday", how do I do it?</p>