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 vote192 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote241 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote203 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote182 views1 answer
How to check even or odd in sql
SQL
1 vote181 views1 answer
Sqlalchemy order_by
SQL
-1 vote173 views3 answers
Check table exist postgresql
SQL
0 vote181 views1 answer
How to see password mysql vestacp
SQL
2 votes184 views1 answer
Mysql add boolean column
SQL
0 vote209 views1 answer
Drush run sql select
SQL
1 vote170 views1 answer
Get count by weekly pivot table sql server
SQL