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 vote194 views1 answer
Psql list rules
SQL
0 vote190 views1 answer
Sql developer export connections
SQL
1 vote214 views1 answer
Sql server today minus n
SQL
2 votes287 views1 answer
Mariadb json select
SQL
6 votes273 views2 answers
Mysql check auto increment value
SQL
1 vote238 views1 answer
Mysql view curren querys
SQL
1 vote189 views1 answer
Stop mysql server mac
SQL
2 votes269 views1 answer
Select a certain number of entries from select mysql
SQL
53 votes605 views6 answers
How to install mysql ubuntu
SQL
1 vote238 views1 answer
Postgresql create table with timestamp
SQL