1.前模糊查询
select * from user like concat('%',#{name})
2.后模糊查询
select * from user like concat(#{name},'%')
3.前后模糊查询
select * from user like concat(concat(#{name},'%'),'%')
1.前模糊查询
select * from user like concat('%',#{name})
2.后模糊查询
select * from user like concat(#{name},'%')
3.前后模糊查询
select * from user like concat(concat(#{name},'%'),'%')