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

3 votes285 views2 answers
How to delete git repo locally
SQL
0 vote273 views1 answer
Postgresql print variable
SQL
16 votes257 views3 answers
Order by sql query
SQL
0 vote285 views1 answer
Microsoft sql server python connection
SQL
0 vote282 views1 answer
Get sum sqlite android
SQL
0 vote264 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
13 votes281 views1 answer
Sql join 3 tables on id
SQL
0 vote258 views1 answer
Remove default constraint sql server
SQL
16 votes271 views3 answers
Delete row psql
SQL
1 vote289 views1 answer
Sqlite update from another table
SQL