title: Retrieve rows less than a day old
body: <p>I have a column <code>date</code>, which has a default value of <code>CURRENT_TIMESTAMP</code>, eg: <code>2011-11-16 15:34:02</code>. Is there any way to put a condition in the mysql statement (not in php) to retrieve rows which are less than a day old? Something like:</p>
  
  <pre><code>SELECT * FROM orders where date &gt; 24 hours ago
  </code></pre>