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

1 vote249 views1 answer
Error code 1055
SQL
2 votes248 views1 answer
Check isolation level in mysql
SQL
0 vote258 views1 answer
Run mssql server terminal
SQL
1 vote262 views1 answer
Base64 encode sql server
SQL
0 vote262 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
1 vote295 views1 answer
Sql random sampling per group
SQL
-2 votes273 views2 answers
Union all in sql
SQL
0 vote246 views1 answer
Initcap in sql
SQL
6 votes209 views2 answers
Generate c# class from sql server table
SQL
0 vote236 views1 answer
Procedures and functions in pl/sql
SQL