mybatis模糊匹配和正则
模糊匹配
<select id="findByName" parameterType="string" resultType="Student">
select * from student where student.name like "%"#{name}"%";
<select>
正则
<select id="findByName" parameterType="string" resultType="Student">
select * from student where student.name REGEXP "^["#{name}"]"
</select>