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 vote307 views1 answer
Suse start MySQL
SQL
28 votes329 views4 answers
Show tables mysql
SQL
0 vote329 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote340 views1 answer
Get who is hired in february in sql
SQL
0 vote351 views3 answers
Fetlife
SQL
36 votes353 views6 answers
Rename table sql
SQL
2 votes324 views3 answers
3 days back in sql server
SQL
7 votes286 views1 answer
Alter table add key sql
SQL
0 vote335 views4 answers
How to connect form to database
SQL
1 vote332 views1 answer
Altering the column name in MySQL to have a default value
SQL