title: mysql - search timestamp by hour of day
body: <p>I have a column named <code>updatetime</code> that is a <code>timestamp</code>. So, for example, an average looking value could be: <code>2011-02-01 09:00:51</code>. I want to be able to search through and return all results for a particular hour of the day regardless of the date. </p>
  
  <p>For example if I searched the column for values <code>BETWEEN 09:00:00 AND 09:59:99</code> it would return:</p>
  
  <pre><code>2011-02-01 09:00:51
  2011-01-31 09:20:51
  2011-01-11 09:55:44
  etc....
  </code></pre>
  
  <p><code>SELECT * FROM table WHERE updatetime ......</code></p>
  
  <p>Thoughts?</p>