我知道,我可以从 DJango ORM 运行不区分大小写的搜索。喜欢,
User.objects.filter(first_name__contains="jake")
User.objects.filter(first_name__contains="sulley")
User.objects.filter(first_name__icontains="Jake")
User.objects.filter(first_name__icontains="Sulley")
而且,我可以将它们获取为
user_list = User.objects.all().order_by("first_name")
# sequence: (Jake, Sulley, jake, sulley)
user_list = User.objects.all().order_by("-first_name") # for reverse
# sequence: (sulley, jake, Sulley, Jake)
有没有直接的方法来不区分大小写的获取?就像我想要一个序列一样
# desired sequence: jake, Jake, sulley, Sulley
如果没有,那么建议最好的方法。提前致谢。
从 Django 1.8 开始,可以:
from django.db.models.functions import Lower
MyModel.objects.order_by(Lower('myfield'))
https://code.djangoproject.com/ticket/6498 https://code.djangoproject.com/ticket/6498
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)