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

6 votes388 views5 answers
Oracle list tablespaces
SQL
0 vote342 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote331 views1 answer
Find all tables where column name exists oracle
SQL
3 votes324 views2 answers
Having in mysql
SQL
1 vote366 views1 answer
Mysql count all table rows
SQL
0 vote336 views1 answer
Sql get guid
SQL
0 vote356 views1 answer
The fetch keyword oracle
SQL
2 votes372 views2 answers
Sqlalchemy return id after insert
SQL
0 vote333 views1 answer
Query on date sqlite flutter
SQL
0 vote332 views1 answer
Php get closest location by latitude longitude
SQL