title: MySQL - Return Row Where Current Date Between Start and End Date
body: <p>I have searched everywhere and can't find an answer for this.</p>
  
  <p>The table below shows the class start and end time. </p>
  
  <p>I am looking to return the row where the current time falls in-between the current start and end time.</p>
  
  <p>The start and End time are going to be variable dependent on current time, so can't input specific values. </p>
  
  <p><a href="https://i.stack.imgur.com/XehP8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XehP8.png" alt="MySQL Table showing Class ID, start and end time"></a></p>
  
  <p>An exmaple being, Say if the current time is:</p>
  
  <p><strong>2016-02-05 20:15:00</strong></p>
  
  <p>Then it would return the row where <strong>Class ID is 6</strong>.</p>