在mybatis中写模糊查询

1.emailMessageMapperEx.selectReceve("%"+title+"%");

<select id="selectReceve" resultMap="BaseResultMap">

select em.id,em.title,em.sender_email
  from email_message em 

  <if test="null!=title">

  where em.title like #{title}

  </if>

</select>

2.<select id="selectReceve" resultMap="BaseResultMap">
select em.id,em.title,em.sender_email
  from email_message em 

  <if test="null!=title">

 <bind name="sub" value="'%' + title + '%'" />

  where em.title like #{sub}

  </if>

</select>

3.  SELECT * FROM tableName WHERE name LIKE CONCAT(CONCAT('%', #{text}), '%');

4.

<select id="selectReceve" resultMap="BaseResultMap">

select em.id,em.title,em.sender_email
  from email_message em 

  <if test="null!=title">

  where em.title like "%"#{title}"%"

  </if>

</select>