Mybatis对Oracle、SQL Server、MySQL、DB2的like模糊查询

MC乱码

已于 2023-10-07 13:22:01 修改

阅读量1.4k

点赞数 2

于 2023-09-28 17:34:41 首次发布

本文链接：https://blog.csdn.net/qq_49641620/article/details/133387475

版权

Oracle

SELECT
	*
FROM
	user
WHERE
<if test='null != name and "" != name and "null" != name'>
	name LIKE CONCAT(CONCAT('%',#{name},'%'))
</if>

或

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}||'%'

通用

SELECT
	*
FROM
	user
WHERE 1 = 1
<if test='name != null and name != ""'>
	<bind name="pattern" value="'%' + name + '%'" />
	AND name LIKE #{pattern}
</if>