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

3 votes159 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
1 vote119 views1 answer
Oracle list constraints
SQL
0 vote113 views1 answer
Mysql auto increment default value with prefix month and year
SQL
11 votes125 views5 answers
Laravel db facade
SQL
4 votes126 views1 answer
What are the data types
SQL
0 vote116 views1 answer
Get created time of database psql 8
SQL
0 vote112 views1 answer
Selects all the columns from the sailors table
SQL
0 vote116 views1 answer
VSCode SQL Server Connection error
SQL
0 vote119 views1 answer
How to find username and password in oracle 18c
SQL
1 vote111 views1 answer
Oracle explain plan
SQL