mysql union 里面加入where like 的查询

Question

如例子：
(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 %'人'%)

望求指导

Answer 1

同上 通配符写到引号里面