/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

11 votes185 views2 answers
Turn off safe mode mysql
SQL
0 vote170 views1 answer
Postgresql get current user name
SQL
0 vote188 views1 answer
Mysql add to number
SQL
0 vote156 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote179 views1 answer
PSQL qith variables
SQL
0 vote195 views1 answer
Offset in postgresql example
SQL
3 votes177 views2 answers
Current year sql
SQL
0 vote188 views1 answer
Django mssql backend
SQL
5 votes198 views1 answer
Sql integer to serial
SQL
0 vote178 views1 answer
Insufficient memory to excute the sql query
SQL