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 vote290 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
1 vote249 views1 answer
Sql myisam vs innodb
SQL
0 vote265 views1 answer
Sql revert migration
SQL
44 votes324 views6 answers
Rename command in sql
SQL
0 vote273 views1 answer
Foreign key multiple columns
SQL
1 vote267 views1 answer
Oracle create index if not exists
SQL
1 vote271 views1 answer
Mysql query bulk insert
SQL
0 vote264 views1 answer
Alter table name including schema
SQL
22 votes284 views4 answers
Mysql date_format
SQL
0 vote316 views1 answer
Psql create usr
SQL