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

1 vote196 views1 answer
Key validation sql
SQL
0 vote173 views2 answers
Create sequence if not exists postgres
SQL
0 vote184 views1 answer
Flush user resource mysql
SQL
0 vote184 views1 answer
Pl sql round
SQL
3 votes183 views1 answer
Set default today mysql
SQL
2 votes182 views2 answers
Select list is not in group by clause
SQL
3 votes182 views1 answer
Ssh check mysql version
SQL
0 vote170 views1 answer
Sql offfset
SQL
1 vote165 views2 answers
How to drop a unique constraint in sql
SQL
0 vote200 views2 answers
Oracle chain rules
SQL