我想要实现 a and (b or c)的sql 的效果
并且 b,c 是从集合中取出的
sql想要实现的效果如下:
select count(*) from xxx where a in ('ROMANIA') and (b like '%?%' or b like '%?%') and c like '%0%'
代码
if (StringUtils.hasText(pojo.getXXX())) {//厂名
List<String> strings = splitString(pojo.getXXX());
Iterator<String> iterator = strings.iterator();
lambdaQueryWrapper.and(wrapper -> {
for (String string : strings) {
wrapper.like(Pojo::getXXX, string);
if (iterator.hasNext()) {
wrapper.or();
}
}
});
}