mybatis-plus-QueryWrapper like的用法

mybatis-plus 中想写like的语句

一、直接用 QueryWrapper 中的 like

  String deptLevelCodeTemp = "1000010001";
  QueryWrapper baseDeptQueryWrapper = new QueryWrapper<>();
  baseDeptQueryWrapper.like("dept_level_code",deptLevelCodeTemp);

  生成的sql语句是：
  select *from base_dept where dept_level_code like '%1000010001%';

二、想要 1000010001%的结果

LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.apply("dept_level_code"+" like {0}", deptLevelCodeTemp+"%");

生成的sql语句是：
select *from base_dept where dept_level_code like '1000010001%';

三、想要 %1000010001的结果

LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.apply("dept_level_code"+" like {0}", "%"+deptLevelCodeTemp);

生成的sql语句是：
select *from base_dept where dept_level_code like '%1000010001';