xml写法
<select id="XXX">
SELECT
*
FROM
user
WHERE
name like CONCAT('%',#{num},'%')
</select>
SELECT
*
FROM
user
WHERE
name like '%'+#{num}+'%'
xml写法
<select id="XXX">
SELECT
*
FROM
user
WHERE
name like CONCAT('%',#{num},'%')
</select>
SELECT
*
FROM
user
WHERE
name like '%'+#{num}+'%'