Mysql order by on condition

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

4 votes129 views2 answers
Dbms output
SQL
0 vote116 views1 answer
Mariadb errno 121
SQL
2 votes120 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote126 views4 answers
How to connect form to database
SQL
32 votes121 views6 answers
How to change column name in sql
SQL
1 vote120 views6 answers
In sql
SQL
0 vote105 views1 answer
Postgresql regular expression special characters
SQL
1 vote74 views1 answer
Mysql see column types
SQL
3 votes114 views1 answer
Uppercase and lowercase in sql
SQL
0 vote118 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL