title: get records from 10am to 4pm
body: <p>Table: TeachersAvailableTime</p>
  
  <pre><code>ID | TeacherID | Day    | startTime | endTime     
  1  | 1         | Mon    | 09:00:00  | 12:00:00    
  2  | 1         | Tue    | 09:00:00  | 16:00:00   
  3  | 1         | Wed    | 09:00:00  | 14:00:00    
  4  | 1         | Thu    | 09:00:00  | 12:00:00    
  5  | 1         | Fri    | 09:00:00  | 16:00:00    
  6  | 1         | Sat    | 09:00:00  | 14:00:00    
  7  | 1         | Sun    | 11:00:00  | 16:00:00    
  8  | 2         | Mon    | 11:00:00  | 12:00:00    
  9  | 3         | Tue    | 12:00:00  | 13:00:00    
  10 | 4         | Wed    | 10:00:00  | 16:00:00
  </code></pre>
  
  <p>I have a teachers available time table and want to get those all teacher who are available on Sat at 10am.</p>
  
  <p>I tried this query </p>
  
  <pre><code>SELECT * FROM working_times WHERE startTime &gt;= '10:00:00' AND endTime &lt;= '16:00:00'
  </code></pre>
  
  <p>but it fails in cases like In this query if I add <code>startTime &gt;= '10:00:00' AND day='Mon'</code> then it is not works correctly, because Teacher 1 is available at 10:00:00 and same issue with endTime</p>