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

0 vote230 views1 answer
Sql get month from date
SQL
0 vote221 views1 answer
List mysql tables and views
SQL
-1 vote231 views2 answers
First letter capital in mysql query
SQL
-1 vote222 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote223 views1 answer
Permission denied postgres \copy csv command line
SQL
3 votes220 views1 answer
Force using index plsql
SQL
0 vote222 views1 answer
Kill thread
SQL
0 vote225 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
-1 vote223 views1 answer
Count occurrences sql
SQL
0 vote232 views3 answers
Postgresql grant alter table to user
SQL