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 vote158 views1 answer
Count of tables in database mysql
SQL
0 vote127 views1 answer
Oracle activate program
SQL
1 vote117 views2 answers
T sql get foreign key
SQL
0 vote145 views1 answer
What is mysql_pconnect
SQL
8 votes130 views1 answer
Oracle find text in functions
SQL
2 votes133 views1 answer
Mysql last 7 days including today
SQL
0 vote136 views1 answer
Delete data from database sqlite android
SQL
2 votes128 views1 answer
While loop sql
SQL
8 votes130 views5 answers
Alter table add column with default value
SQL
0 vote152 views1 answer
Connect to ssms with python
SQL