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 vote137 views1 answer
Mysql show create db
SQL
7 votes130 views4 answers
How to reset the identity column in sql server
SQL
12 votes144 views6 answers
Change mysql root password
SQL
0 vote183 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
4 votes138 views1 answer
Create column mysql terminal
SQL
0 vote156 views1 answer
000webhost database values insert
SQL
0 vote124 views1 answer
Mysql user set plugin
SQL
1 vote126 views4 answers
Fatal database postgres does not exist
SQL
0 vote151 views1 answer
Oracle winter time change
SQL
0 vote129 views1 answer
Oracle call a function in a insert statement
SQL