title: Mysql DATETIME evaluation: Get all records whose value is before midnight of the current day (basically yesterday and before
body: <p>This is really simple yet I always struggle with it. I need help getting records before midnight:</p>
  
  <pre><code> AND last_checked &lt; date('2013-06-25 00:00:00'))
  </code></pre>
  
  <p>This obviously doesn't work, since its string evaluation. I do not want to restrict it to this year and put a between in the code. Any help is extremely appreciated :)</p>