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 vote260 views1 answer
Oracle session statistics
SQL
0 vote231 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote207 views1 answer
Mariadb list tables
SQL
3 votes241 views1 answer
Créer une table sql
SQL
2 votes234 views1 answer
Oracle drop table free up space
SQL
1 vote239 views1 answer
Mysql f# examples
SQL
19 votes261 views3 answers
Grant mysql
SQL
2 votes234 views4 answers
List databases in sql server
SQL
0 vote258 views1 answer
Pgadmin save data greyed out
SQL
0 vote245 views1 answer
How to check event scheduler status mysql
SQL