模糊匹配查询:select * from customer where username like '%n%'
错误写法:select * from customer where username like '%#{username}%'
原因:日志分析说明过: "#{name}" 相当于 "?占位符" 如果传的是字符串会带双引号所以会变成select * from customer where username like '%'n'%'
解决方案:CONCAT('%','n','%')
select * from customer where username like CONCAT('%',#{username},'%')