mybatis like查询%_JAVA_编程开发_程序员俱乐部

?

class="sql" name="code">--all
select * from user where name like '%${name}%

--mysql,oracle,db2
select * from user where name like concat('%',#{name},'%') 

--oracle,db2
select * from user where name like '%'||#{name}||'%'

--SQL Server
select * from user where name like '%'+#{name}+'%'

--据说这种是预编译，有空测下
select * from user where name like "%"#{name}"%"

?

?