Mybatis模糊查询语句的几种写法:
mysql: select * from tbl_school where school_name like concat('%',#{name},'%')
oracle: select * from tbl_school where school_name like '%'||#{name}||'%'
SQL Server: select * from tbl_school where school_name like '%'+#{name}+'%'
Oracle有以下几种:
select * from person where name like "%"#{name}"%" 貌似不能运行
select * from person where name like '%'||#{name}||'%' 能运行
select * from person where name like '%${name}%' 查询的数据不对
第一种属于预编译SQL,后两种都不是,因此推荐使用第一种写法。