How to query Case-insensitive data in Django ORM?

by

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.

More Related Contents:

  1. How to filter empty or NULL names in a QuerySet?
  2. How to view corresponding SQL query of the Django ORM’s queryset?
  3. Why does django’s prefetch_related() only work with all() and not filter()?
  4. Select DISTINCT individual columns in django?
  5. django-orm case-insensitive order by
  6. Django: implementing JOIN using Django ORM?
  7. Creating Partial Indexes with Django 1.7
  8. When saving, how can you check if a field has changed?
  9. How to express a One-To-Many relationship in Django?
  10. Override default queryset in Django admin
  11. How to create an object for a Django model with a many to many field?
  12. Setting the selected value on a Django forms.ChoiceField
  13. Django: Set foreign key using integer?
  14. Django migrate –fake and –fake-initial explained
  15. LEFT JOIN Django ORM
  16. django – get() returned more than one topic
  17. Django – how to specify a database for a model?
  18. “Post Image data using POSTMAN”
  19. Django model: delete() not triggered
  20. Django accessing ManyToMany fields from post_save signal
  21. Dropdown in Django Model
  22. Django unique_together with nullable ForeignKey
  23. Django: ManyToMany filter matching on ALL items in a list
  24. How to add a sortable count column to the Django admin of a model with a many-to-one relation?
  25. How to use custom manager with related objects?
  26. Password field in Django model
  27. Django: dynamic database file
  28. conversion of datetime Field to string in django queryset.values_list()
  29. Django Rest framework, how to include ‘__all__’ fields and a related field in ModelSerializer ?
  30. Saving Many To Many data via a modelform in Django

Leave a Comment