-
book_list = Book.objects.filter(price__gt=50).values("name","price")
print("查询价格大于50"+str(book_list))
-
b = Book.objects.filter(name__contains="p").values("name","price")
-
b = Book.objects.filter(name__icontains="p").values("name","price")
print("查询含有p(不在乎大小写)的名字"+str(b))
-
b = Book.objects.filter(id__lt=10,id__gt=1).values("id","name")
print("查询id大于1小于10"+str(b))
-
b = Book.objects.filter(id__in=[5,6,7]).values("id", "name")
print("查询id等于5,6,7" + str(b))
-
b = Book.objects.filter(id__range=[5, 10]).values("id", "name")
print("查询id在5到10" + str(b))
-
#startwith,endwith,istartwith,iendwith