python - How can django sql queries use case insensitive and contains at the same time?

Question

Suppose I have two users with username 'AbA' and 'aBa' in the database. My query word is 'ab'.

I used

User.objects.filter(username__contains='ab')

and

User.objects.filter(username__iexact='ab')

These two queries get empty result. However, I want to use something like username__contains__iexact='ab' that can retrieve both 'AbA' and 'aBa'.

Anyone know how to resolve this problem? Thanks.

question from:https://stackoverflow.com/questions/5935447/how-can-django-sql-queries-use-case-insensitive-and-contains-at-the-same-time

Answer 1

Use:

User.objects.filter(username__icontains='ab')