带条件的 Mysql group_concat

Question

我认为这很少见，不确定是否可能。

我有这个问题:

$sql = "SELECT id_product,GROUP_CONCAT(id_tag  ORDER BY id_tag  ) AS producto  
FROM ps_product_tag  
where id_product = '194'
GROUP BY id_product";

我得到了这个结果:

Array ( [id_product] => 194 [producto] => 36,190,273,274,275,276,277,278,279,280,281,282,284,286,287,289 ) 

我需要做的是使用多个 where 条件过滤 id_tag 结果数组。

WHERE t.`id_tag` = '275'
AND t.`id_tag` = '282'
AND t.`id_tag` = '286'
AND t.`id_tag` = '289'

但是我做不到。

谁能帮帮我

Answer 1

您可以像这样添加一个 HAVING 子句:

SELECT
    id_product,
    GROUP_CONCAT(id_tag ORDER BY id_tag) AS producto,
    COUNT(*) as `n`
FROM ps_product_tag
WHERE id_tag IN ('275', '282', '286', '287')
GROUP BY id_product
HAVING `n`=4