title: Select rows that are less than 5 minutes old using DATE_SUB
body: <p>I have a table that is getting hundreds of requests per minute.  The issue that I'm having is that I need a way to select only the rows that have been inserted in the past 5 minutes. I am trying this:</p>
  
  <pre><code>SELECT count(id) as count, field1, field2
  FROM table
  WHERE timestamp &gt; DATE_SUB(NOW(), INTERVAL 5 MINUTE)
  ORDER BY timestamp DESC
  </code></pre>
  
  <p>My issue is that it returns 70k+ results and counting.  I am not sure what it is that I am doing wrong, but I would love to get some help on this.  In addition, if there were a way to group them by minute to have it look like:</p>
  
  <pre><code>| count | field1 | field2 | 
  ----------------------------
  </code></pre>
  
  <p>I'd love the help and direction on this, so please let me know your thoughts.</p>