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

18 votes253 views2 answers
Sql inner join
SQL
0 vote224 views1 answer
Query for maximum salary
SQL
0 vote270 views1 answer
Set Mamp mysql globally
SQL
0 vote267 views2 answers
Mysql on update current_timestamp
SQL
-2 votes275 views2 answers
Union vs union all in sql
SQL
1 vote298 views1 answer
Find size of all DB's postgres
SQL
3 votes280 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
2 votes267 views2 answers
How to check data type in sql server
SQL
0 vote294 views1 answer
Mysql 3 months ago
SQL
0 vote312 views1 answer
Mariadb.service failed with result 'exit-code'
SQL