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

12 votes308 views10 answers
Google
SQL
1 vote298 views1 answer
Convert varchar to int in sqlite
SQL
1 vote334 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote338 views1 answer
Drop a view in sqlite
SQL
17 votes306 views4 answers
Sort by mysql
SQL
0 vote296 views2 answers
Postgres another version
SQL
0 vote299 views1 answer
Two inner joins sql
SQL
1 vote321 views1 answer
Update substring in mysql
SQL
0 vote296 views3 answers
Osx stop mysql service
SQL
0 vote319 views1 answer
Postgres foreign key multiple columns
SQL