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 vote366 views2 answers
Sql queries practice
SQL
0 vote339 views1 answer
Sql view index
SQL
0 vote383 views1 answer
Add created and updatedAt fields in mysql
SQL
8 votes346 views1 answer
Show mysql user table
SQL
0 vote348 views1 answer
Mysql count grouped rows
SQL
3 votes329 views3 answers
Mysql select table names
SQL
0 vote369 views1 answer
Oracle session statistics
SQL
0 vote386 views1 answer
Dual in db2
SQL
0 vote350 views1 answer
List all functions and procedures in postgres query
SQL
0 vote331 views2 answers
Select limit ms sql
SQL