原文:https://www.cnblogs.com/icewee/articles/6927841.html
> 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>
|