Django之单表查询——神奇的双下划线

1.filter中的单表查询

    # 查询id>1且id<4的结果
    ret = models.Person.objects.filter(id__gt=1,id__lt=4)
    print(ret)

    # 查询id在[1,3,5,7]
    ret = models.Person.objects.filter(id__in=[1,3,5,7])
    print(ret)

    # contians
　　 # icontains忽略大小写
    ret = models.Person.objects.filter(name__contains='黑')
    print(ret)

    # range 两端都可以取到
    # 判断id值在哪个区间的 SQL语句中的between  and
    ret = models.Person.objects.filter(id__range=[1,3]) 
    print(ret)

    # 日期和时间字段还可以有以下的写法
    ret = models.Person.objects.filter(birthday__year=2000)
    print(ret)
    ret = models.Person.objects.filter(birthday__year=2000,birthday__month=5)
    print(ret)