MyBatis动态sql中模糊查询

1、直接拼接%%：

<select id="getActiveDatas" parameterType="java.util.Map" resultType="java.util.Map">

  select * from tab_test where is_deleted = 0
  <if test="frameNo != null and frameNo != '%%'">
  and frame_no like '%${frameNo}%'
  </if>
  </select>

2、定义 一个<bind/>变量：

<select id="getActiveDatas" parameterType="java.util.Map" resultType="java.util.Map">

  <bind name="frameNo" value="'%' + _parameter.frameNo + '%'" />
  select <include refid="textDatas"/> from tab_test where is_deleted = 0
  <if test="frameNo != null and frameNo != '%%'">
  and frame_no like #{frameNo}
  </if>

</select>

3、使用locate()函数：

<select id="getActiveDatas" parameterType="java.util.Map" resultType="java.util.Map">

  select * from tab_test where is_deleted = 0
  <if test="frameNo != null and frameNo != ''">
  and LOCATE(#{frameNo}, frame_no ) > 0
  </if>
 </select>

4、使用instr()函数：

<select id="getActiveDatas" parameterType="java.util.Map" resultType="java.util.Map">

  select * from tab_test where is_deleted = 0
  <if test="frameNo != null and frameNo != ''">
  and INSTR(frame_no , #{frameNo})
  </if>
 </select>