Two 'order by' in a MySQL query (older date DESC, newer date ASC)

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.

Untitled-1

simply separate the order by commas, for example:

SELECT title, date FROM table1 ORDER BY date ASC, title DESC

ofc you can put ASC or DESC after each column name, or omit it and use your engine’s default:

... ORDER BY date, title DESC
... ORDER BY date ASC, title
... ORDER BY date, title, id