<select id=selectByNameLike" parameterType="string" resultMap="BaseResultMap">
SELECT
*
FROM
a
LEFT JOIN b ON a.bid = b.id
WHERE
a.NAME LIKE concat ("%", #{name},"%")
<select>
原文：https://www.cnblogs.com/itzyz/p/12590101.html