Django Model - Case-insensitive Query / Filtering

database django django-models filtering
Ron picture Ron · Jul 31, 2012 · Viewed 91.8k times · Source

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)

Answer

Ron picture Ron · Jul 31, 2012

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.

Related questions

Django Model() vs Model.objects.create()

What it the difference between running two commands: foo = FooModel() and bar = BarModel.objects.create() Does the second one immediately create a BarModel in the database, while for FooModel, the save() method has to be called explicitly to add it …

Read More
Django error - matching query does not exist

I finally released my project to the production level and suddenly I have some issues I never had to deal with in the development phase. When the users posts some actions, I sometimes get the following error. Traceback (most recent …

Read More
Django is "unable to open database file"

after running "python manage.py syncdb" i gett an error saying "unable to open database file". here is the important part from my settings.py: DATABASE_ENGINE = 'sqlite3' # 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'. DATABASE_NAME = …

Read More