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 vote311 views1 answer
Install postgresql 12 on debian 10
SQL
2 votes314 views1 answer
Pandas to sql index
SQL
21 votes310 views3 answers
Sql average
SQL
0 vote308 views2 answers
SQL Server Standard
SQL
14 votes318 views3 answers
Oracle sql limit results
SQL
0 vote363 views1 answer
How to convert external table to managed table in hive
SQL
0 vote292 views1 answer
Clone table structure mysql
SQL
0 vote306 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote335 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
1 vote302 views1 answer
Get url of cpanel database hostname
SQL