I need some help with a query where I want order my results like the image below. So everything newer than today should be ASC everything older than today should be DESC
SELECT title, date FROM table1 ORDER BY date < NOW () DESC AND ORDER date > Now() ASC
I don’t know if it’s even possible.