How to write MySql query with multiple data orders?
SELECT ......ORDER BY (event_date = curdate()) DESC, // today's events (event_date > curdate()) DESC, // future events event_date DESC; // past events
Something like this maybe?
SELECT * FROM tbl_event ORDER BY event_date DESC WHERE DATE(event_date) = DATE(NOW()) UNION SELECT * FROM tbl_event ORDER BY event_date DESC WHERE event_date >= NOW() UNION SELECT * FROM tlb_event ORDER_BY event_date DESC WHERE event_date < NOW()