mybatis一个查询同时查询两个字段，两个字段之间用或

LambdaQueryWrapper<MaintenancePlan> wrapper = new LambdaQueryWrapper<>();
if (StrUtil.isNotEmpty(queryReq.getSearchCodeAndName())){
    wrapper.and(e -> e.like(MaintenancePlan::getMaintenancePlanCode,queryReq.getSearchCodeAndName()).or()
            .like(MaintenancePlan::getMaintenancePlanName,queryReq.getSearchCodeAndName()));
}

SQL执行如下

select  maintenance_plan_code, maintenance_plan_name, device_code, plan_interval_start_time , plan_interval_end_time, status
from maintenance_plan where del_flag = '0' and ((maintenance_plan_code like '%6%' or maintenance_plan_name like '%6%') and status = 0) order by create_time desc