您现在的位置是:首页 > 文章详情

djang常用查询SQL语句

日期:2019-01-28点击:281

将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` 
原文链接:https://my.oschina.net/hellotest/blog/3006595
关注公众号

低调大师中文资讯倾力打造互联网数据资讯、行业资源、电子商务、移动互联网、网络营销平台。

持续更新报道IT业界、互联网、市场资讯、驱动更新,是最及时权威的产业资讯及硬件资讯报道平台。

转载内容版权归作者及来源网站所有,本站原创内容转载请注明来源。

文章评论

共有0条评论来说两句吧...

文章二维码

扫描即可查看该文章

点击排行

推荐阅读

最新文章