title: How to get current shift by current Time from Mysql database
body: <p>Here is my table : <strong>shift_master</strong></p>
  
  <pre><code>shift(varchar)     | start_time(varchar) | end_time(varchar)    
  Morning            | 06:00 AM            | 02:00 PM    
  AfterNoon          | 02:00 PM            | 10:00 PM    
  Evening            | 10:00 PM            | 06:00 AM
  </code></pre>
  
  <p>I need one query in which I will pass the current time and it will give the record of shift which is currently going on.</p>
  
  <p>I really appreciate your help.</p>