MyBatis中Like语句使用总结

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}||'%'

使用mybatis标签:

<select id="selectPersons" resultType="person" parameterType="person">
  <bind name="pattern" value="'%' + _parameter.username + '%'" />
  select id,sex,age,username,password 
  from person
  where username LIKE #{pattern}
</select>