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

3 votes116 views2 answers
Get current year sql
SQL
0 vote106 views1 answer
Postgres week number
SQL
0 vote130 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
4 votes102 views1 answer
Mysql set max connections
SQL
0 vote101 views1 answer
Sqldf change user
SQL
14 votes118 views1 answer
Sql value of string
SQL
0 vote110 views1 answer
Select all columns except one sql
SQL
0 vote110 views1 answer
How to update date value in sql
SQL
1 vote103 views2 answers
How to check username in mysql command line
SQL
3 votes103 views1 answer
Sql select all
SQL