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 vote174 views4 answers
Sql server date format yyyy-mm-dd
SQL
2 votes155 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
13 votes157 views2 answers
Get date from now() mysql
SQL
10 votes165 views3 answers
How to fetch first 5 characters in sql
SQL
14 votes158 views3 answers
Sql trim from string
SQL
0 vote204 views2 answers
Insert data into multiple tables mysql
SQL
0 vote147 views1 answer
Mysql calculated column
SQL
-1 vote173 views1 answer
Mysql extract days
SQL
0 vote147 views1 answer
Mysql table variables
SQL
0 vote198 views1 answer
Stop and start mysql
SQL