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 vote181 views1 answer
What alter does in db
SQL
1 vote203 views2 answers
Mysql between
SQL
7 votes196 views5 answers
Show details of table postgres
SQL
-1 vote165 views1 answer
Mysql if example
SQL
2 votes197 views2 answers
Postgresql search all tables for column name
SQL
2 votes195 views2 answers
Checking data type in sql server
SQL
0 vote190 views1 answer
Sql delete where x or y or z
SQL
-1 vote197 views3 answers
Create temp table in sql
SQL
0 vote209 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote196 views1 answer
How to add boolean column in postgresql
SQL