模糊查询(like函数)

select * from user where name  LIKE CONCAT(#{user_name}, '%')

select * from user where name like '%万里哥%'
原文地址:https://www.cnblogs.com/wanlige/p/14522833.html