模糊查询(like函数) select * from user where name LIKE CONCAT(#{user_name}, '%') select * from user where name like '%万里哥%'