<select id="findByName" resultMap="baseFeedbackMap">
SELECT * FROM tbl_base_feedback f
<where>
1=1
<if test="startTime != null and startTime != ''">
<if test="endTime != null and endTime != ''">
and f.creat_time >=#{startTime}
and f.creat_time <=#{endTime}
</if>
</if>
<if test="keyword != null and keyword != ''">
and (f.name like '%'|| #{keyword} ||'%' OR f.phone like '%'|| #{keyword} ||'%' OR f.content like '%'|| #{keyword} ||'%')
</if>
</where>
order by f.creat_time desc
</select>
sql时间段查询
最新推荐文章于 2024-08-26 03:39:39 发布