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>