如何在主查询中添加以选择子查询的多个值
如何在主查询中添加以选择子查询的多个值
提问于 2014-12-22 06:40:03
查询：
SELECT *
FROM `wp_posts`
WHERE `ID`
IN GROUP_CONCAT(
(
SELECT post_id
FROM `wp_postmeta`
WHERE `meta_key` = 'friday_happy_hour_start_time'
AND `meta_value` <= '9'
) && (
SELECT post_id
FROM `wp_postmeta`
WHERE `meta_key` = 'friday_happy_hour_end_time'
AND `meta_value` >= '9'
)
)Subquery 1和2具有多个结果，因此我使用了GROUP_CONCAT()。但这是行不通的。我要所有9等于的帖子，或者是meta_value('s) of meta_key = 'friday_happy_hour_end_time‘和meta_key =’meta_key_高兴小时_start_time‘之间的帖子。
Stack Overflow用户
发布于 2014-12-22 08:25:33
SELECT *
FROM `wp_posts`
WHERE `ID` IN (
SELECT DISTINCT post_id
FROM `wp_postmeta`
WHERE `meta_key` = 'friday_happy_hour_start_time'
AND `meta_value` <= '9'
UNION DISTINCT
SELECT DISTINCT post_id
FROM `wp_postmeta`
WHERE `meta_key` = 'friday_happy_hour_end_time'
AND `meta_value` >= '9'
)页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/27597669
复制相关文章
相似问题
腾讯云开发者
