mysql子集输出,MYSQL子集操作

最新推荐文章于 2023-04-18 11:54:59 发布

诚身

最新推荐文章于 2023-04-18 11:54:59 发布

阅读量85

点赞数

文章标签： mysql子集输出

本文介绍如何使用SQL实现，根据用户选择的多个动态标签（value1, value2, value3），查询项目表（project）中包含所有这些标签的项目。通过projectTagMap表进行关联，当用户选定的标签集合是goodvalue=true项目的子集时，显示完整项目信息；否则，不显示任何结果。

摘要由CSDN通过智能技术生成

Is there a way to achieve something like:

SELECT *

FROM tb_values

WHERE (value1, value2, value3) SUBSET_OF

( SELECT value

FROM tb_value

WHERE isgoodvalue = true

)

More information:

I have a table called projects. Each project has tags. A tag can be shared by multiple projects. There is a mapping table called projectTagMap. Now users use tags to filter the projects. Tags are selected using checkboxes on the UI. So a user selects several tags to filter the projects. Am supposed to select the projects from projects table that contains all the tags selected by the user.

解决方案

From your pseudo code I guess that you want to check if a (dynamic) list of values is a subset of another list provided by a SELECT. If yes, then a whole table will be shown. If not, no rows will be shown.

Here's how to achieve that:

SELECT *

FROM tb_values

WHERE

( SELECT COUNT(DISTINCT value)

FROM tb_value

WHERE isgoodvalue = true

AND value IN (value1, value2, value3)

) = 3

UPDATED after OP's explanation:

SELECT *

FROM project