title: SELECT a time between two times range
body: <p>I want to select some rows that match a certain hour interval. So I tried doing this but it doesn't work</p>
  
  <pre><code>SELECT * 
    FROM geocoord 
   WHERE ID = "3574" 
     AND startTime &lt; TIME_FORMAT("00:00:00","%h %m %s") 
     AND endTime &gt; TIME_FORMAT("05:00:00","%h %m %s")
  </code></pre>
  
  <p>What I want to do is select all the rows where the ID is 3574 that match between 12 AM to 5 AM</p>