方式1:
select * from person where name like "%"#{name}"%"
方式2:
select * from person where name like '%'||#{name}||'%'
方式3:
select * from person where name like '%${name}%'
方式4:
select * from person where name like CONCAT('%',#{name},'%')
方式1:
select * from person where name like "%"#{name}"%"
方式2:
select * from person where name like '%'||#{name}||'%'
方式3:
select * from person where name like '%${name}%'
方式4:
select * from person where name like CONCAT('%',#{name},'%')
转载于:https://www.cnblogs.com/boblogsbo/p/5320613.html