MyBatis中Like语句使用方式

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

> 通用

SELECT
* 
FROM
user
WHERE 1 = 1
<if test="name != null and name != ''">
<bind name="pattern" value="'%' + _parameter.name + '%'" />
AND name LIKE #{pattern}
</if>
posted @ 2020-07-08 11:50  南北12345678  阅读(3626)  评论(0)  编辑  收藏  举报