mysql union 里面加入where like 的查询

如例子：
(SELECT b.goodsName FROM t_base_group_buy as a
LEFT JOIN t_goods_list as b on a.goodsId=b.id
WHERE a.goodsType=1 and b.goodsName LIKE %'人'%)
UNION
(SELECT b.goodsName FROM t_base_group_buy as a
LEFT JOIN t_pre_goods_list as b on a.goodsId=b.id
WHERE a.goodsType=0 and b.goodsName LIKE %'人'%)

望求指导

同上 通配符写到引号里面

额，百分号是应该在引号里面的吧

同上，引号包含在百分号外边