如题:
Mysql中 :select * from table where name like concat('%',#{参数},'%');
Oracle中 : select * from table where name like '%' || #{参数} || '%';
如题:
Mysql中 :select * from table where name like concat('%',#{参数},'%');
Oracle中 : select * from table where name like '%' || #{参数} || '%';