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 vote169 views1 answer
Add alternate add column sql
SQL
1 vote163 views1 answer
Trigger in postgresql to change incoming entry
SQL
1 vote168 views2 answers
Oracle replace
SQL
1 vote216 views1 answer
Top 10 rows in mysql
SQL
0 vote160 views1 answer
What are the aggregate function in sql
SQL
3 votes184 views4 answers
Psql list tables in schema
SQL
1 vote182 views1 answer
Sql server get users
SQL
0 vote160 views1 answer
Find number of entries sql
SQL
0 vote161 views1 answer
Mysql convert charset
SQL
0 vote157 views1 answer
Find and replace database table phpmyadmin
SQL