FILTER BY SINGLE COLUMN IN SQL 
SELECT *
FROM Person
WHERE id = 1;

FILTER BY SINGLE COLUMN IN DJANGO

Person.objects.filter(id=1)
FILTER BY COMPARISON OPERATORS IN SQL 
WHERE age > 18;
WHERE age >= 18;
WHERE age < 18;
WHERE age <= 18;
WHERE age != 18;

FILTER BY COMPARISON OPERATORS IN DJANGO

Person.objects.filter(age__gt=18)
Person.objects.filter(age__gte=18)
Person.objects.filter(age__lt=18)
Person.objects.filter(age__lte=18)
Person.objects.exclude(age=18)
BETWEEN IN SQL 
SELECT *
FROM Person
WHERE age BETWEEN 10 AND 20;

BETWEEN IN DJANGO

Person.objects.filter(age__range=(10, 20))
LIKE OPERATOR IN SQL 
		
WHERE name like '%A%';
WHERE name like binary '%A%';
WHERE name like 'A%';
WHERE name like binary 'A%';
WHERE name like '%A';
WHERE name like binary '%A';

LIKE OPERATOR IN DJANGO

Person.objects.filter(name__icontains='A')
Person.objects.filter(name__contains='A')
Person.objects.filter(name__istartswith='A')
Person.objects.filter(name__startswith='A')
Person.objects.filter(name__iendswith='A')
Person.objects.filter(name__endswith='A')
IN OPERATOR IN SQL 
WHERE id in (1, 2);

IN OPERATOR IN DJANGO

Person.objects.filter(id__in=[1, 2])]
Prev next