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 vote355 views1 answer
Calculate age in sql
SQL
0 vote343 views2 answers
Sql server Insert Into table
SQL
44 votes392 views6 answers
Rename command in sql
SQL
0 vote323 views1 answer
Update row in sqlite python
SQL
0 vote346 views2 answers
Select columns from 2 tables with foreign key
SQL
-1 vote331 views3 answers
Update mongodb version ubuntu
SQL
0 vote343 views1 answer
Search column name sql
SQL
0 vote341 views2 answers
Create fulltext index mysql
SQL
3 votes361 views1 answer
Laravel database Using Named Bindings
SQL
16 votes417 views2 answers
Sql vs nosql
SQL