Use "contains" and "iexact" at the same query in DJANGO

python django django-queryset
rayashi picture rayashi · Apr 5, 2012 · Viewed 34.8k times · Source

How can I use contains and iexact Field lookups at the same query in Django?

Like that ..

casas = Casa.objects.filter(nome_fantasia__contains__iexact='green')

Answer

agf picture agf · Apr 5, 2012

If you need case-insensitive contains, use icontains:

casas = Casa.objects.filter(nome_fantasia__icontains = 'green')

Which is converted to

... WHERE nome_fantasia ILIKE '%green%'

in SQL.

Related questions

How do I do a not equal in Django queryset filtering?

In Django model QuerySets, I see that there is a __gt and __lt for comparative values, but is there a __ne or != (not equals)? I want to filter out using a not equals. For example, for Model: bool a; int …

Read More
How do I filter query objects by date range in Django?

I've got a field in one model like: class Sample(models.Model): date = fields.DateField(auto_now=False) Now, I need to filter the objects by a date range. How do I filter all the objects that have a date …

Read More
How can I filter a Django query with a list of values?

I'm sure this is a trivial operation, but I can't figure out how it's done. There's got to be something smarter than this: ids = [1, 3, 6, 7, 9] for id in ids: MyModel.objects.filter(pk=id) I'm looking to get them all in …

Read More