How to order events close to today's date
I have a table that stores events with the php timestamp format. I would like to get the next 10 events.
SELECT * FRO开发者_Go百科M myTBL WHERE event_time >= TODAY ORDER BY (The closest time to today)
Any help on writing this query would be greatly appreciated.
SELECT * FROM myTBL WHERE event_time >= TODAY ORDER BY event_time ASC
精彩评论