AND IN SQL
SELECT *
FROM Person
WHERE gender='male' AND age > 25;

AND IN DJANGO

Person.objects.filter(gender='male', age__gt=25)
OR IN SQL
SELECT *
FROM Person
WHERE gender='male' OR age > 25;

OR IN DJANGO

from django.db.models import Q
Person.objects.filter(Q(gender='male') | Q(age__gt=25)))
NOT IN SQL
SELECT *
FROM Person
WHERE NOT gender='male';

NOT IN DJANGO

Person.objects.exclude(gender='male')
Prev next