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

0 vote323 views1 answer
Sql check if field is not null
SQL
8 votes245 views1 answer
Sql remove characters from string right
SQL
0 vote252 views7 answers
10 random questions use python and SQL
SQL
0 vote245 views1 answer
What is the essence of SQL?
SQL
1 vote302 views1 answer
Create new table from old table
SQL
5 votes252 views1 answer
Sql asynchronous stored procedure call
SQL
1 vote259 views1 answer
Mysql show table character set
SQL
3 votes266 views3 answers
Sql last week
SQL
0 vote249 views1 answer
Mysql begin statement
SQL
12 votes282 views2 answers
Select into insert sql server
SQL