title: Find records with a date field in the last 24 hours
body: <p>In my SQL query how do i make it find the records in the last 24 hours?
  Eg</p>
  
  <pre><code>   SELECT * FROM news WHERE date &lt; 24 hours
  </code></pre>
  
  <p>I usually do it by setting a variable to date() - 1 day and comparing it to that but I wondered whether the sql query way was faster?</p>