Use "contains" and "iexact" at the same query in DJANGO
django, django-queryset, python
Solution
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.
Problem
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') ```