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)

Akaisteph7 · Accepted Answer · 2024-08-12 21:16:10Z

600

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)

Akaisteph7

6,9222 gold badges39 silver badges53 bronze badges

answered Jul 31, 2012 at 15:08

Ron

23.6k33 gold badges115 silver badges216 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Would you please explain what "substring search" means?

@RishabhAgrahari You search inside a string, for example you search for "beer" and you get the matches "beer" and "beers".

And for example a match with "there is beer in my stomach".

Well done sir, this has given me like 3 hours of trouble :)

|