Use “contains” and “iexact” at the same query in DJANGO

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.