title: MySQL: select query, 5 minute increment
body: <p>I have a weather database which gets datasets about every 70 seconds (depends on when the weather-station delivers the data).<br>
  I want to graph it using Pchart but i have too many samples so the X axis is screwed up.<br>
  So i want the data for about every 5 minutes. (or every 30 minutes)<br>
  The query i currently have is this:</p>
  
  <pre><code>SELECT time, temp_out FROM wmr200 WHERE date(time) = curdate()
  </code></pre>
  
  <p>This gets the samples for the last 24 hours but there are too many.</p>