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 vote327 views1 answer
Sqlite insert or update
SQL
0 vote311 views1 answer
Sql server select value large text
SQL
4 votes318 views4 answers
What is primary key
SQL
0 vote298 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote326 views1 answer
Print hello world in plsql
SQL
6 votes309 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
123 votes522 views5 answers
Sql where contains
SQL
1 vote315 views1 answer
Sql server epoch to datetime
SQL
1 vote302 views1 answer
Select inside insert query
SQL
1 vote307 views1 answer
Postgresql reset serial counter after deleting content
SQL