django-model

1.models.Account.objects.filter(id =  1)

 

2. like语句(不敏感)    models.Account.objects.filter(password_startswith='a')    

 

3.select * from Acciunt where password like(%a%) (不敏感)    models.Account.objects.filter(username__contains='a')  （默认是敏感的）   icontains  默认是敏感的等同与like

 

4.select * from app01_account where username id in (1,2)      models.Account.objects.filter(id__in = [1,2,3])    models.Account.objects.filter(username__in = ['alex','jack'])

 

5.gt  : Greater than     gte  :  Greater than or equal to      lt :less than     lte  :  Less than or equal to

 

6.startswith   : Case-sensetive starts-with

 

7. models.Account.objects.filter(headline__startwith = 'Lennon')        select * from Acciunt where password like(a%) 

 

8.istartswith     Case-insensitive starts-with

 

9.endswith       Case-sensitive ends-with

 

10.iendswith    Case-insensitive ends-with