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

0 vote180 views1 answer
Grepper sql workbench download
SQL
3 votes170 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
1 vote184 views1 answer
Get all db sizes in mysql server
SQL
0 vote177 views1 answer
Mysql function variable
SQL
5 votes210 views1 answer
Oracle nls instance
SQL
16 votes201 views2 answers
Sql exists
SQL
3 votes181 views1 answer
Oracle APEX elapsed time
SQL
0 vote189 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
1 vote191 views3 answers
Reset sql primary key
SQL
0 vote195 views1 answer
Find the names of sailors who have reserved at least one boat
SQL