Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to filter objects by ignoring upper and lower case letter django

recently I started learning django and I have several questions. And one of them has relationship with __icontains.

Company.objects.filter(name__icontains=receiver_company_name)

And let's assume that I have one company which called for example Dota-2, and when I search in my db this company by typing "D", it's return for me Dota-2. And my question will be about, if my company "Dota-2" it's saved in db like this "Dota-2", and when I trying to search like this lowercase "d", it's return me empty array. How to make name_icontains search by ignoring lower and uppercase letter?

like image 629
Baktiyar Bekbergen Avatar asked Jul 12 '17 11:07

Baktiyar Bekbergen


1 Answers

Blog.objects.get(name__iexact=receiver_company_name)

you can use iexact which takes all the arguments ignoring upper and lower case

or you can use

Entry.objects.filter(name__istartswith=receiver_company_name)
like image 200
Exprator Avatar answered Oct 20 '22 07:10

Exprator