本文介绍了如何选择与所有必需标签匹配的帖子?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个包含两列的表格,博客文章 ID 和标签 ID.一篇博客文章可以有多个标签,比如一篇关于纽约"和苏荷"的文章.假设我想找到所有标签 ID 为 1 和 2 的博客文章,我该怎么做?
I have a table with two columns, blog post ids and tag ids. A blog post can have several tags like it's a post about "New York" and "Soho". Let's say I want to find all the blog posts that have BOTH tag id 1 and 2, how do I do that?
blogPostToTags ============================= id |tagId ----------------------------- 1 |1 1 |2 2 |1 3 |2更新:
我尝试了以下方法:
SELECT id FROM blogPostToTags WHERE tagId = 1 AND tagId = 2和
SELECT id FROM blogPostToTags WHERE tagId = 1 OR tagId = 2不管用...
推荐答案使用双JOIN.
SELECT id FROM blogPosts p INNER JOIN blogPostToTags pt1 ON pt1.id = p.id INNER JOIN blogPostToTags pt2 ON pt2.id = p.id WHERE pt1.tagId = 1 AND pt2.tagId = 2;更多推荐
如何选择与所有必需标签匹配的帖子?
发布评论