mybatis-bind
<select id="getEmpByConditionIf" parameterType="com.example.demo.entity.Employee" resultType="com.example.demo.entity.Employee">
<bind name="_param" value="'%'+last_name+'%'"/>
SELECT * FROM tbl_employee
WHERE last_name LIKE #{_param}
</select >