<select id="selectAllmsgByParam" resultType="com.casom.car.pojo.membersugess.MemberSuggest" parameterType="com.casom.common.PageParam">
SELECT
id,
title,
content,
create_date AS createDate,
update_date AS updateDate
FROM
member_suggest
<where>
is_delete = 0
<if test="params != null " >
<if test="params.id != null and params.id != ''">
AND id =#{params.id}
</if>
<if test="params.title != null and params.title != ''">
AND title LIKE '%${params.title}%'
</if>
<if test="params.content != null and params.content !=''">
AND content LIKE '%${params.content}%'
</if>
</if>
</where>
ORDER BY
create_date DESC
</select>