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 votes175 views4 answers
Order by desc postgres
SQL
0 vote180 views1 answer
Mysql min value row
SQL
1 vote183 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
1 vote163 views1 answer
Sql drop with dependencies
SQL
0 vote182 views1 answer
ORA-00942
SQL
0 vote165 views1 answer
Sql create table with datetime automatically
SQL
1 vote180 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
11 votes178 views1 answer
Mysql order by two columns priority
SQL
0 vote165 views1 answer
Oracle date summer time
SQL
0 vote188 views1 answer
Grant privileges of databse to user
SQL