djangodjango-modelsfilterdjango-ormcase-insensitive

How to query Case-insensitive data in Django ORM?


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)

Solution

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