在使用like模糊查询时,一般写法是:select * from user where username like "%三%"。也可以写为:select * from user where username like "%"'三'"%"。根据这种写法使用#{}可以写为:
select * from user where username like "%"#{value}"%"
或者使用concat函数
select * from user where username like concat("%",#{value},"%")