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 votes159 views2 answers
Install sqlalchemy
SQL
0 vote166 views1 answer
TSQL convert csv to table
SQL
0 vote124 views2 answers
Postgresql display subquery as json
SQL
1 vote200 views1 answer
Mysql connect command
SQL
3 votes156 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote148 views1 answer
ORA-13717
SQL
2 votes142 views1 answer
Mysql query unique column
SQL
1 vote127 views1 answer
Sql server 2016 reseed identity
SQL
18 votes145 views4 answers
Mysql current date between two dates
SQL
19 votes228 views5 answers
Mysql between date range
SQL