Modulus in django query

Question

How would I do the following SQL in the django ORM:

SELECT * FROM main_titlemaster WHERE id % 4 = 0

The model name is TitleMaster.

score 3 · Accepted Answer · answered Sep 24 '14 at 22:17

3

You can use the .extra():

TitleMaster.objects.extra(where=['id mod 4=0'])

answered Sep 24 '14 at 22:17

David542

For anyone arriving here, considering using this solution: The docs do no recommend using it. > This is an old API that we aim to deprecate at some point in the future. – decibyte May 25 '23 at 14:12

score 0 · Answer 2 · answered May 25 '23 at 14:25

According to the docs, the correct way of doing this today is using an F() expression:

Django supports the use of addition, subtraction, multiplication, division, modulo, and power arithmetic with F() objects

This should do the trick:

TitleMaster.objects.annotate(mod_four=F("id") % 4).filter(mod_four=0)

2 Answers2