djang常用查询SQL语句-优快云博客

本文详细对比了Django ORM语法与SQL语句在数据库查询操作上的应用,包括单列查询、条件组合查询、空值查询、模糊匹配及集合运算等,帮助读者深入理解两者之间的转换关系。

将django语法和sql对应一下，希望对大家有所帮助
查询单个列的值

story.object.values_list("url", flat=True)
SELECT story.url FROM hbtc_story WHERE story.status = resolved
AND查询

Stories.objects.filter(Q(status='resolved') & Q(status='developing'))
SELECT * FROM story WHERE (story.status = resolved AND story.status = developing)
或查询

Stories.objects.filter(Q(status='resolved') | Q(status='developing'))
SELECT * FROM story WHERE (story.status = resolved OR story.status = developing)
NOT查询

Stories.objects.filter(~Q(status='resolved'))
SELECT * FROM story WHERE NOT (story.status = resolved)
查询为空

Stories.objects.filter(status__isnull=True)
SELECT * FROM story WHERE story.plan_id_id IS NULL
like查询

Stories.objects.filter(status__contains='resolved')
SELECT * FROM story WHERE story.status LIKE BINARY %resolved%;
Stories.objects.filter(status__endswith='resolved')

SELECT * FROM story WHERE story.status LIKE BINARY %resolved;
Stories.objects.filter(status__istartswith='resolved')

SELECT * FROM story WHERE story.status LIKE BINARY resolved%;
in查询

Stories.objects.filter(status__in=('resolved',))

SELECT * FROM story WHERE story.status IN (resolved) ;
distinct查询

story.object.values_list("status", flat=True).distinct()
SELECT DISTINCT story.status FROM story