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)

Ligialignaloes

Answer 1

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)

There's a link to the documentation.

Ligialignaloes

Would you please explain what "substring search" means? – Spectra

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

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

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

It is sql like – Hindenburg

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