<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>