使用GROUP BY 去重, 使用 HAVING sum >= 2 判断查询出来的数据超过同一字段的查询条件数量,取到同时符合条件的数据
SELECT c.* FROM `goods` `a` INNER JOIN `goods_category_relate` `b` ON `a`.`goods_id`=`b`.`goods_id` INNER JOIN `goods_attr` `c` ON `a`.`goods_id`=`c`.`goods_id` INNER JOIN `goods_attribute` `d` ON `c`.`attr_id`=`d`.`attr_id` WHERE ( `attr_value` LIKE '%1080%' OR `attr_value` LIKE '%100*200%' ) AND `delete_time` = 0 GROUP BY `c`.`goods_id` HAVING sum >= 2
神兽