jwinf843

Sql	                                                    QuerySet	                                     Notes
SELECT count(*) FROM fruit	                      Fruits.objects.count()	                          table count
SELECT count(*) FROM fruit WHERE name=’Orange’        Fruits.objects.filter(name__exact=’Orange’).count() count with filter
SELECT * FROM fruit WHERE color is NULL	              Fruits.objects.get(color__isnull=True)	          filter by null
SELECT * FROM fruit WHERE color is NOT NULL	      Fruits.objects.get(color__isnull=False)	          filter by null
SELECT * FROM fruit WHERE name=’Apple’	              Fruits.objects.get(name__exact=’Apple’)	          case sensitive
SELECT * FROM fruit WHERE lower(name)=lower(‘Apple’)  Fruits.objects.get(name__iexact=’Apple’)            case in-sensitive
SELECT * FROM fruit WHERE name LIKE ‘App%’	      Fruits.objects.filter(name__startswith=’App’)       case sensitive LIKE
SELECT * FROM fruit WHERE upper(name) LIKE ‘APP%’     Fruits.objects.filter(name__ista