like条件查询
<select id="queryListByCondition" resultMap="BaseResultMap">
select
<include refid="Base_Column_List"/>
from e_user
<where>
status = '0'
<if test="username != null and username != ''">
and username like concat("%",#{username},"%")
</if>
<if test="phone != null and mobile !=''">
and phone like concat("%",#{phone},"%")
</if>
</where>