oracle数据库:
或
SQLServer数据库:
mysql数据库:
DB2数据库:
或
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}||'%'