I have a table 'tickets' with the following columns
- id - primary key - auto increment
- title - varchar(256)
- status - smallint(6) - Can have any value between 1 and 5, handled by Django
When I'll do a SELECT *
I want the rows with status = 4
at the top, the other records will follow them. It can be achieved by the following query:
select * from tickets order by status=4 DESC
Can this query be executed through Django ORM? What parameters should be passed to the QuerySet.order_by()
method?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…