可以用在模糊查询中,加入两个% %
- value 指传入的参数处理后的值
- name 就是引用时的name
<select id="getEmpByBind" resultType="emp" databaseId="mysql">
<bind name="_lastName" value="'%'+name+'%'"/>
select last_name as lastName, email,id,gender from employee where last_name like #{_lastName}
</select>