mysql 数据库
第一种
- SELECT * FROM t_app
- <where>
- <if test="name != null">
- name like CONCAT('%','${name}','%' )
- </if>
- <if test="url != null">
- AND url like CONCAT('%','${url}','%' )
- </if>
- </where>
- limit #{begin},${end}
第二种
<if test="activityName != null" >
and activityName like '%${activityName}%'
</if>
第三种
select * from t_blog where title like "%"#{title}"%"