oracle数据库:
SELECT *
FROM user
WHERE name like CONCAT('%',#{name},'%')
或
SELECT *
FROM user
WHERE name like '%'||#{name}||'%'
SQL Server数据库:
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}||'%'