Mysql 查找包含多个标签的文章？

[alayii]

文章包含多个标签，用关联表外理，表 articles, re_articles_tags, tags

如何能查找即有 A 标签又有 B 标签的文章？

[cevincheung]

select * from articles where article_id in (select distinct(article_id) from tags where tags in ('tag1','tag2','tag3')) limit n

[caixiexin]

select distinct a.* from articles a, re_articles_tags b where a.文章id=b.文章id and b.tag in (A ,B)
?

[feiyuanqiu]

一个能用但是不太好的 SQL：

SELECT
DISTINCT a.*
FROM
re_articles_tags r1
JOIN re_articles_tags r2
ON r1.`article_id` = r2.`article_id`
AND r1.`tag_id` = 1
AND r2.`tag_id` = 2
JOIN articles a
ON r1.`article_id` = a.`article_id`

[pi1ot]

这应该是适合lucene做的事情