Querrying mysql table for times after the current one

Question

Hi!

I have a table with 1 column (bus departure times in format "14:32:15"). How to querry the table to show only departures that are after the current moment (after curtime())? E.g.: if it's 12 o'clock and my table has rows (10:15:00,11:20:00,12:30:00, ...), i want to have 12:30:00 returned.

Answer 1

Try this SELECT time FROM yourtable WHERE time > now()