Django query case-insensitive list match

by

Unfortunatley, there are no __iin field lookup. But there is a iregex that might be useful, like so:

result = Name.objects.filter(name__iregex=r'(name1|name2|name3)')

or even:

a = ['name1', 'name2', 'name3']
result = Name.objects.filter(name__iregex=r'(' + '|'.join(a) + ')')

Note that if a can contain characters that are special in a regex, you need to escape them properly.

NEWS: In Django 1.7+ it is possible to create your own lookups, so you can actually use filter(name__iin=['name1', 'name2', 'name3']) after proper initialization. See documentation reference for details.

More Related Contents:

  1. How can I combine two or more querysets in a Django view?
  2. How do I do an OR filter in a Django query?
  3. How to filter empty or NULL names in a QuerySet?
  4. Custom QuerySet and Manager without breaking DRY?
  5. Why does django’s prefetch_related() only work with all() and not filter()?
  6. Select DISTINCT individual columns in django?
  7. _set in Django for a queryset
  8. Raw SQL queries in Django views
  9. How to limit queryset/the records to view in Django admin site?
  10. Django: implementing JOIN using Django ORM?
  11. Django – filtering on foreign key properties
  12. How to create a Django queryset filter comparing two date fields in the same model
  13. Django Queryset with filtering on reverse foreign key
  14. How to dynamically provide lookup field name in Django query? [duplicate]
  15. Django lazy QuerySet and pagination
  16. Django: ManyToMany filter matching on ALL items in a list
  17. Django query datetime for objects older than 5 hours
  18. Django, query filtering from model method
  19. Django: Does prefetch_related() follow reverse relationship lookup?
  20. django most efficient way to count same field values in a query
  21. Django Order By Date, but have “None” at end?
  22. Django: __in query lookup doesn’t maintain the order in queryset
  23. Django queryset get exact manytomany lookup [duplicate]
  24. how to write a query to get find value in a json field in django
  25. How to revert the last migration?
  26. django admin login suddenly demanding csrf token
  27. How to force a user logout in Django?
  28. Django unique_together with nullable ForeignKey
  29. Default image for ImageField in Django’s ORM
  30. How to show related items using DeleteView in Django?

Leave a Comment