Mysql order by on condition

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 vote144 views2 answers
How to delete the rows with null values in mysql
SQL
1 vote478 views1 answer
Mysql event last execution
SQL
0 vote148 views1 answer
Kotlin sqlite delete row
SQL
0 vote147 views1 answer
Mysql docker image for macbook m1
SQL
1 vote136 views1 answer
Oracle lock user
SQL
6 votes139 views4 answers
Eloquent to sql with bindings
SQL
4 votes157 views1 answer
Oracle user tables
SQL
0 vote160 views1 answer
Sql select column name like from multiple tables
SQL
0 vote144 views1 answer
Power query case when
SQL
0 vote166 views1 answer
Compression of dabatase mysqldumo
SQL