MySQL选择：WHERE（现在时间）= BETWEEN tablevalue和tablevalue

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:I'm looking for a way to select the row in whic