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

1 vote195 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
1 vote196 views1 answer
Declare variables sql
SQL
3 votes240 views2 answers
How to View column names of a table in SQL
SQL
2 votes261 views3 answers
3 days back in sql server
SQL
0 vote214 views2 answers
Transaction php
SQL
0 vote297 views1 answer
SQL query to verify the size of the table
SQL
1 vote225 views1 answer
Raw query must include primary key
SQL
15 votes191 views3 answers
Find duplicate keys in mysql
SQL
0 vote203 views1 answer
How to create a new shema using query languaage
SQL
0 vote191 views1 answer
Oracle current session details
SQL