title: Comparing time range in mysql
body: <p>I have a three column startTime and EndTime as a Time datatype and amount as a int.
  I want to compare time if 10:00:00 is in between startTime and Endtime it should return the amount in that range </p>
  
  <p>My startTime is 08:00:00 and endTime is 14:00:00</p>
  
  <p>I tried </p>
  
  <pre><code>SELECT amount
    from table 
   where startTime &gt;='10:00:00' 
     AND endTime &lt;='10:00:00' 
  </code></pre>
  
  <p>But it does not work I even tried CAST as time, it did not work too. </p>
  
  <p>I tried looking at other post but none of suggested solution worked. </p>