/SQL/Mysql order by where condition sub query

Mysql order by where condition sub query

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

Similar codes

1 vote129 views1 answer
Mysql select another database
SQL
8 votes157 views2 answers
Grant all privileges database postgres to user
SQL
29 votes134 views5 answers
Mysql show table structure
SQL
20 votes152 views4 answers
Sql count if
SQL
51 votes237 views6 answers
Change column name sql
SQL
0 vote145 views1 answer
Sql server size of every table in a db
SQL
1 vote145 views1 answer
Sql week commencing date
SQL
0 vote125 views2 answers
How to start postgresql laravel
SQL
0 vote158 views3 answers
Insert query in ci
SQL
0 vote129 views2 answers
Show slave status mysql
SQL