Django Model - Case-insensitive Query / Filtering

django django-models filter django-orm case-insensitive

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)

Ron

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)

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".

doc for iexact: docs.djangoproject.com/en/dev/ref/models/querysets/#iexact

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

Success story sharing