Danjgo学习笔记（五）----Django数据库的查询

 

ORM数据库查询:

1、exact: 精准查询
eg:
article = Article.objects.filter(title__exact="嘻嘻")
print(article)

2、iexact 模糊查询
eg:
article = Article.objects.filter(title__iexact="嘻嘻")
print(article.query)
print(article)
==
SELECT `Article`.`id`, `Article`.`title`, `Article`.`context`, `Article`.`author` FROM `Article` WHERE `Article`.`title` LIKE 嘻嘻

3、contains 模糊查询(区分大小写)
eg:
article = Article.objects.filter(title__contains="哈")
print(article.query)
print(article)

==
SELECT `Article`.`id`, `Article`.`title`, `Article`.`context`, `Article`.`author` FROM `Article` WHERE `Article`.`title` LIKE BINARY %哈%

4、icontains 模糊查询
eg:
SELECT `Article`.`id`, `Article`.`title`, `Article`.`context`, `Article`.`author` FROM `Article` WHERE `Article`.`title` LIKE %哈%

5、__gt 大于 __gte 大于等于 __lt 小于 __lte 小于等于
eg:
article = Article.objects.filter(id__gt = 2)
print(article.query)
print(article)

==
SELECT `Article`.`id`, `Article`.`title`, `Article`.`context`, `Article`.`author` FROM `Article` WHERE `Article`.`id` > 2

6、startswith、istartswith、endswith、iendswith
表示以某个值开始，不区分大小写的以某个值开始、以某个值结束、不区分大小写的以某个值结束