django_ORM_数据库取值

        # 查询方法1：直接查询
        models.Info_Phone.objects.filter(mobile="157137632",id=2)

        # 查询方法2：把查询条件放在字典里面
        data_list = {"mobile":"157137632","id":2}
        models.Info_Phone.objects.filter(**data_list)

        # 针对数字：id等
        models.Info_Phone.objects.filter(id=2)  # 等于12
        models.Info_Phone.objects.filter(id__gt=2)  # 大于12
        models.Info_Phone.objects.filter(id__gte=2)  # 大于等于12
        models.Info_Phone.objects.filter(id__lt=2)  # 小于12
        models.Info_Phone.objects.filter(id__lte=2)  # 小于等于12

        data_list = { "id__gt": 2}
        models.Info_Phone.objects.filter(**data_list)

        # 针对字符串
        models.Info_Phone.objects.filter(mobile="15713763208")  # 等于
        models.Info_Phone.objects.filter(mobile__startswith="157")  # 筛选出以157开头的
        models.Info_Phone.objects.filter(mobile__endswith="3208")  # 筛选出以3208结尾的
        models.Info_Phone.objects.filter(mobile__contains="157")  # 筛选出保函157的
        data_list = {"mobile__contains":"157" }
        models.Info_Phone.objects.filter(**data_list)