title: mysql select where where datetime is within this hour
body: <p>Hi I am trying to select row's where the datefiled eg <code>11-11-2011 12:00</code> is equal to the current hour.</p>
  
  <p>Sorry, to add it should match the whole date but round to the hour.</p>
  
  <p>Here's what I have so far :</p>
  
  <pre><code>SELECT * FROM emails WHERE SUBSTRING(datetosend,0,12) = SUBSTRING(NOW(),0,12)
  </code></pre>