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 vote270 views1 answer
Mysql readable output
SQL
2 votes190 views1 answer
Enum in SQL Server
SQL
11 votes175 views1 answer
Mysql order by two columns priority
SQL
10 votes200 views1 answer
How to import database in mysql by cmd
SQL
0 vote182 views1 answer
Will graphql replace sql
SQL
33 votes186 views6 answers
Change column name in mysql
SQL
0 vote191 views4 answers
Sql rownum
SQL
0 vote206 views1 answer
Oracle concat datetime
SQL
0 vote174 views1 answer
Postgresql find missing id
SQL
0 vote229 views1 answer
Get from database the most recent data limit by 5
SQL