How to query Case-insensitive data in Django ORM?

Question

How can I query/filter in Django and ignore the cases of my query-string?

I've got something like and like to ignore the case of my_parameter:

MyClass.objects.filter(name=my_parameter)

score 564 · Accepted Answer · answered Jul 31 '12 at 15:08

564

I solved it like this:

MyClass.objects.filter(name__iexact=my_parameter)

There is even a way to use it for substring search:

MyClass.objects.filter(name__icontains=my_parameter)

answered Jul 31 '12 at 15:08

Ron

Would you please explain what "substring search" means? – Rishabh Agrahari Jan 28 '17 at 12:45
7

@RishabhAgrahari You search inside a string, for example you search for "beer" and you get the matches "beer" and "beers". – Ron Jan 31 '17 at 08:33
4

And for example a match with "there is beer in my stomach". – gornvix Apr 22 '17 at 22:34
4

doc for iexact: https://docs.djangoproject.com/en/dev/ref/models/querysets/#iexact – Anupam Dec 29 '17 at 10:24
It is sql `like` – Kasper Ziemianek May 01 '18 at 15:16
2

Well done sir, this has given me like 3 hours of trouble :) – ViaTech Jan 17 '19 at 02:42

1 Answers1