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 vote115 views1 answer
Trigger in postgresql to change incoming entry
SQL
0 vote134 views1 answer
Alter check command
SQL
0 vote142 views1 answer
Snowflake drop column
SQL
7 votes135 views1 answer
Oracle reset sequence
SQL
0 vote128 views1 answer
Dapper run sql script with parameters
SQL
0 vote135 views1 answer
Count characters of string mysql
SQL
0 vote125 views1 answer
Mysql select distinct date from timestamp
SQL
1 vote117 views2 answers
Mysql current user
SQL
0 vote142 views1 answer
Play framework connection via windows sql server
SQL
0 vote148 views1 answer
Show all sequences postgres
SQL