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 vote171 views1 answer
Soql last week
SQL
0 vote157 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote178 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote183 views1 answer
Alter column to not null with default value sql server
SQL
20 votes164 views6 answers
Mysql reset auto increment
SQL
0 vote164 views1 answer
Neo4j command to run script file
SQL
0 vote188 views1 answer
Prisma transaction
SQL
0 vote167 views1 answer
How to drop a trigger in postgresql
SQL
0 vote183 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote141 views1 answer
Remove binlog mysql
SQL