title: How to select rows that have current day's timestamp?
body: <p>I am trying to select only today's records from a database table.</p>
  
  <p>Currently I use</p>
  
  <pre><code>SELECT * FROM `table` WHERE (`timestamp` &gt; DATE_SUB(now(), INTERVAL 1 DAY));
  </code></pre>
  
  <p>But this takes results for the last 24 hours, and I need it to only select results from today, ignoring the time. How can I select results based on the date only ?</p>