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

2 votes376 views1 answer
How to check if a row is null in sql
SQL
0 vote317 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote360 views1 answer
Python mysql show databases
SQL
0 vote341 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote358 views1 answer
Ceil upto 2 decimal place mysql
SQL
2 votes343 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote349 views2 answers
Add colum in sql
SQL
0 vote333 views1 answer
Running query in redshift
SQL
1 vote335 views1 answer
Python escape mysql
SQL
0 vote307 views1 answer
Postgres add prefix to primary key
SQL