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 vote118 views1 answer
Find and replace query in wordpress\
SQL
0 vote119 views1 answer
Find most frequent value in SQL column
SQL
0 vote136 views2 answers
Call to undefined function mysql_query()
SQL
0 vote117 views1 answer
How to find columns with null values in sql
SQL
15 votes124 views2 answers
Sql order by multiple columns
SQL
4 votes125 views2 answers
Postgresql default value
SQL
0 vote125 views1 answer
Mysql update even / odd rows
SQL
17 votes134 views5 answers
Order by sql
SQL
5 votes105 views1 answer
Sql first day of current year
SQL
0 vote116 views1 answer
How to login to mysql in homestead
SQL