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 vote236 views1 answer
Psql show db
SQL
0 vote228 views1 answer
Mysqli last row
SQL
1 vote366 views2 answers
Sql unique rows
SQL
0 vote246 views1 answer
Postgre query date
SQL
1 vote209 views1 answer
Select not matching data from two tables
SQL
15 votes228 views4 answers
Mysql where value is null
SQL
2 votes223 views1 answer
Add default sql server
SQL
12 votes224 views1 answer
Script to add new column in table sql
SQL
0 vote261 views1 answer
Jpa generationtype sequence mysql
SQL
1 vote235 views1 answer
Oracle get current schema
SQL