title: Mysql Query back to midnight only
body: <p>I have this query that looks up results from a database for the last twenty minutes, now i know how to look up in hours, days, etc, but is it possible to look up only as far back as midnight of that day. so when ever the query is run and what ever time it only looks back as far as midnight?</p>
  
  <pre><code>SELECT * FROM ip_stats WHERE date &gt;= ( NOW() - INTERVAL 20 MINUTE ) and ip='$ip'
  </code></pre>
  
  <p>This is my code but is there away in which i can replace the interval for a specific time.</p>
  
  <p>Any help would be appreciated.</p>