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 vote141 views2 answers
Postgresql variable in query
SQL
0 vote150 views1 answer
Calculer pourcentage mysql
SQL
0 vote135 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote123 views1 answer
Change data type in mysql
SQL
3 votes149 views2 answers
Sql not contains
SQL
0 vote82 views2 answers
Delete query sql server
SQL
0 vote133 views1 answer
Sql server count all tables rows
SQL
0 vote131 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote202 views1 answer
Add user mysql wordpress
SQL
10 votes154 views4 answers
Fetch first 5 characters of the string in sql
SQL