title: Find all rows between two hours of the day
body: <p>Here's my problem :</p>
  
  <p>I have a table like this :</p>
  
  <pre><code>id  date                name
  543 2012-07-30 09:49:08 test
  544 2012-07-30 10:54:12 test2
  545 2012-08-01 10:54:12 test3
  </code></pre>
  
  <p>The thing is, I want to select all the records that were registred <code>today</code> between (for exemple) 9 and 12. How can I achieve this ?</p>
  
  <p>I know how to do it like "HOURS(date) between 9 and 12" but I want MySQL to take in consideration the date of the day.</p>
  
  <p>Thanks !</p>