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

16 votes158 views1 answer
Sql comment'
SQL
0 vote156 views1 answer
Oracle decode
SQL
1 vote163 views2 answers
Mysql does sentance contain word
SQL
3 votes145 views2 answers
See mysql users ubuntu
SQL
6 votes150 views4 answers
Mysql group by month
SQL
0 vote82 views1 answer
FindAllBy
SQL
4 votes131 views1 answer
Check database name postgresql
SQL
0 vote181 views1 answer
Postgres select from values
SQL
1 vote140 views2 answers
Pad zero sql server
SQL
7 votes148 views1 answer
Query delete duplicates
SQL