Condition in orderby mysql

SELECT orders.status, orders.created_at
FROM `orders`
ORDER BY
  status='new' DESC,
  status='processing' DESC,
  CASE WHEN status IN ('new', 'processing') THEN created_at END ASC,
  CASE WHEN status NOT IN ('new', 'processing') THEN created_at END DESC

-1

Similar codes

0 vote100 views1 answer
Mssql current date
SQL
0 vote97 views2 answers
Show slave status mysql
SQL
0 vote150 views1 answer
Sql select without column name
SQL
-1 vote101 views5 answers
Not in sql
SQL
0 vote115 views1 answer
Add SuperUser MySQL
SQL
0 vote105 views1 answer
Object Information
SQL
0 vote99 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote114 views1 answer
Oracle date summer time
SQL
0 vote159 views3 answers
Insert or ignore postgres
SQL
0 vote110 views1 answer
Psql list view rules
SQL