模糊查询（like函数）

 

 

 

--Mapper文件中
select * from user where name  LIKE CONCAT('%',CONCAT(#{firstName}, '%'))

select * from user where name like '%万里哥%'