1.emailMessageMapperEx.selectReceve("%"+title+"%");
<select id="selectReceve" resultMap="BaseResultMap">
select em.id,em.title,em.sender_emailfrom email_message em
<if test="null!=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_emailfrom email_message em
<if test="null!=title">
</if>
</select>