MyBatis中Like语句使用方式(转)

原文出处：http://w6513017.iteye.com/blog/1512761

oracle数据库： 

SELECT
*
FROM
user
WHERE
name like CONCAT('%',#{name},'%')

或 

SELECT
*
FROM
user
WHERE
name like '%'||#{name}||'%'

SQLServer数据库： 

SELECT
*
FROM
user
WHERE
name like '%'+#{name}+'%'

mysql数据库： 

SELECT
*
FROM
user
WHERE
name like CONCAT('%',#{name},'%')

DB2数据库： 

SELECT
*
FROM
user
WHERE
name like CONCAT('%',#{name},'%')

或 

SELECT
*
FROM
user
WHERE
name like '%'||#{name}||'%'