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

16 votes406 views1 answer
Sqlserver add column to table
SQL
16 votes352 views4 answers
Sort by sql
SQL
0 vote339 views1 answer
Call procedure in wordpress
SQL
0 vote385 views1 answer
Postgres meta command to show all rows in table
SQL
4 votes348 views5 answers
Primary key
SQL
1 vote342 views1 answer
Show structure of table in sql
SQL
0 vote326 views1 answer
Sql query for select from specific columns in a table
SQL
1 vote344 views1 answer
Oracle create index if not exists
SQL
1 vote354 views1 answer
Where date = max(date) in sql
SQL
10 votes348 views4 answers
Mysql one week ago
SQL