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}||'%'
原文链接:https://blog.csdn.net/u010648555/article/details/76368153
文章评论