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 vote133 views3 answers
Sql parenthetical expression examples
SQL
0 vote133 views1 answer
Enable sql server full text indexing
SQL
0 vote128 views1 answer
How to check the port of mysql installation in mac
SQL
3 votes137 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote145 views1 answer
Oracle job session
SQL
0 vote77 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
1 vote112 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote120 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote140 views2 answers
What is the default password for sql server sa
SQL
0 vote121 views1 answer
IIF
SQL