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

5 votes150 views3 answers
Sql make column nullable
SQL
0 vote211 views1 answer
Get last inserted primary key
SQL
1 vote178 views1 answer
Mysql show database size in mb
SQL
0 vote143 views1 answer
Mysql cdn link
SQL
0 vote142 views1 answer
Is not null postgresql
SQL
0 vote148 views1 answer
Delete record by id sql
SQL
0 vote149 views1 answer
Mysql count with two joins
SQL
0 vote148 views1 answer
Sql period overlap
SQL
0 vote148 views1 answer
Sql if else in select
SQL
0 vote158 views1 answer
T-SQL - Where Used List (Table/View)
SQL