title: how do i get mysql results of todays date?
body: <p>I'm trying to pull results from a table that have been inserted today. Each insert is marked with a timestamp.</p>
  
  <p>If I do a query like:</p>
  
  <pre><code>SELECT * 
    FROM table 
    WHERE added &gt; DATE_SUB(NOW(), INTERVAL 1 DAY) 
  </code></pre>
  
  <p>It seems I get stuff that did fall on today's date, but also stuff from 24 hours ago. maybe I'm seeing things. </p>
  
  <p>I don't want to see stuff from 24 hours ago...</p>