在wrapper中写
wrapper.like(“mp.area_code”,code).or().like(“mp.city_code”,code);
但是实际上需要的sql是
WHERE (mo.id =‘1242255615092092930’ AND a.project_id = ‘1318461344380948481’ AND (mp.area_code LIKE ‘%130500%’ OR mp.city_code LIKE ‘%130500%’))
所以wrapper应该这样写:
wrapper.and(Wrapper -> Wrapper.like(“mp.area_code”,code)
.or().like(“mp.city_code”,code));
记录一下