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 vote135 views2 answers
Update query with between in mysql
SQL
0 vote114 views1 answer
How to list function in psql
SQL
-1 vote117 views1 answer
Mac mysql workbench console
SQL
1 vote109 views1 answer
Oracle explain plan
SQL
5 votes114 views1 answer
JBDC
SQL
0 vote178 views1 answer
Alter table name including schema
SQL
0 vote131 views1 answer
What logs are available on RDS MySQL?
SQL
34 votes140 views6 answers
Install mysql client ubuntu
SQL
0 vote138 views1 answer
Plpgsql create function
SQL
0 vote106 views1 answer
Java input type sql date
SQL