尚学堂模糊小于

模糊查询和小于判断

select * from emp where ename like '%张%';

select * from emp where ename like contact('%','张','%');

在xml中可以这样写

select * from emp where ename like contact('%',#{ename},'%');

小于判断

select * from emp where sal < #{sal}