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

Question

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 1

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.