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 vote360 views1 answer
Oracle allow space to user
SQL
0 vote365 views2 answers
Dbms interview questions
SQL
0 vote369 views1 answer
Mariadb current date plus 1 day
SQL
0 vote362 views7 answers
Les jointures sql server
SQL
0 vote348 views1 answer
Cara menampilkan user di mysql terminal
SQL
14 votes366 views4 answers
Remove record from table sql
SQL
0 vote359 views3 answers
Average salary in sql
SQL
-1 vote317 views1 answer
Plsql while
SQL
0 vote353 views1 answer
How to output a different column name in mysql
SQL
4 votes339 views1 answer
SQL order random
SQL