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

5 votes199 views1 answer
Mysql change primary key
SQL
0 vote216 views1 answer
SQL add a totals of differemt rows of the same id
SQL
5 votes195 views3 answers
Truncate function in sql oracle
SQL
1 vote207 views1 answer
Describe table in sql
SQL
0 vote224 views1 answer
Mssql unique key accept nulls
SQL
0 vote209 views1 answer
Selecting duplicates
SQL
9 votes195 views4 answers
How to remove duplicate in sql
SQL
6 votes204 views1 answer
Phpmyadmin password root
SQL
1 vote192 views1 answer
Adding a default constraint to an existing column in sql
SQL
1 vote222 views1 answer
How to convert number to hours and minutes in oracle sql
SQL