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 vote205 views1 answer
Sql server roles and users
SQL
0 vote200 views2 answers
Sql query in dax power bi
SQL
0 vote199 views1 answer
How change the field place in mysql
SQL
0 vote201 views1 answer
Mysql group by derived column
SQL
1 vote202 views2 answers
T-sql random number for each row
SQL
0 vote174 views0 answer
SQL
0 vote189 views2 answers
How to relationship query two different tables in MySQL
SQL
10 votes208 views2 answers
Forgot my mysql password mac
SQL
0 vote198 views1 answer
Ajax error exception handeling
SQL
0 vote223 views1 answer
Data types mysql vs postgresql
SQL