title: MySQL Select: WHERE (time now) = BETWEEN tablevalue AND tablevalue
body: <p>I'm looking for a way to select the row in which the current time is between two set values in the row. I've set up a table with 3 columns, 2 of them hold a timestamp (HH:MM:SS), the other one a string. Is there a way I can get the string corresponding to the current time?
  To put it in a more abstract way:</p>
  
  <p>SELECT String FROM TableName WHERE (Current Time) BETWEEN (Lower Limit Time Value) AND (Upper Limit Time Value);</p>
  
  <p><img src="https://i.stack.imgur.com/zoEuC.jpg" alt="alt text"></p>
  
  <p>So basically, based on the current time, my script should output the correct string.</p>
  
  <p>How do I go about this?
  Thanks!</p>