解决查询一个数据库表符合多个条件的语句参考

解决查询一个数据库表符合多个条件的语句参考

SELECT * FROM `oc_product_filter` WHERE `filter_id` = 31 OR `filter_id` = 38 GROUP BY `product_id` HAVING COUNT(`product_id`)=2

SELECT `product_id` FROM (SELECT `product_id`,group_concat(`filter_id`) as g FROM `oc_product_filter` where `filter_id` in (31,38,39) group by `product_id` ) temp WHERE temp.g = “31,38,39”