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 vote192 views1 answer
Sql cmd no truncate
SQL
0 vote166 views1 answer
How to execute stored output to csv files
SQL
2 votes252 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote184 views1 answer
Multiple left join mysql
SQL
-1 vote194 views1 answer
Concat two columns in sql server
SQL
7 votes180 views2 answers
Add column table pl sql
SQL
0 vote179 views1 answer
MySQL FIND_IN_SET()
SQL
5 votes153 views1 answer
Alter table default value mysql
SQL
21 votes244 views6 answers
Update sql
SQL
11 votes180 views2 answers
Oracle source code
SQL