mysql数据库:
SELECT
*
FROM
user
WHERE
name like CONCAT('%',#{name},'%')
oracle数据库:
SELECT
*
FROM
user
WHERE
name like CONCAT('%',#{name},'%')
或者
SELECT
*
FROM
user
WHERE
name like '%'||#{name}||'%'
SQLServer数据库:
SELECT
*
FROM
user
WHERE
name like CONCAT('%',#{name},'%')
DB2数据库:
SELECT
*
FROM
user
WHERE
name like CONCAT('%',#{name},'%')
或者
SELECT
*
FROM
user
WHERE
name like '%'||#{name}||'%'
原文地址:http://w6513017.iteye.com/blog/1512761
欢迎访问我的csdn博客,我们一同成长!
“不管做什么,只要坚持下去就会看到不一样!在路上,不卑不亢!”