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

1 vote353 views1 answer
Concat first name and last name in mysql
SQL
1 vote289 views1 answer
Postgresql update auto_increment value
SQL
3 votes327 views1 answer
Oracle list user grants
SQL
0 vote330 views1 answer
Mysql drop trigger
SQL
0 vote327 views1 answer
Sql server pivot rows to columns
SQL
0 vote362 views1 answer
Sql query inline if
SQL
2 votes298 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote322 views1 answer
Sintaxis SELECT sql
SQL
0 vote326 views1 answer
Postgresql combine values in one field
SQL
0 vote293 views1 answer
Mysql date + 1 day
SQL