SELECT
tp_exam_base_info.id,
exam_title,
IFNULL( file_path, 0 ) AS file_path,
an_number
FROM
tp_exam_base_info
LEFT JOIN sys_file_manage ON tp_exam_base_info.file_id = sys_file_manage.id
WHERE
type_id = #{id}
and expiry_date = 0
<![CDATA[and UNIX_TIMESTAMP(start_date) <= UNIX_TIMESTAMP(NOW())]]>
<!-- 强制转换小于等于 -->
and UNIX_TIMESTAMP(end_date) >= UNIX_TIMESTAMP(NOW())
OR expiry_date = 1
<if test="examName !=null and examName!='' ">
and exam_title LIKE CONCAT('%',#{examName,jdbcType=VARCHAR},'%')
</if>
ORDER BY
tp_exam_base_info.${roleName} ${role};
或者
<if test="map.begin != null and map.begin !='' and map.end != null and map.end !='' ">
AND DATE_FORMAT(a.posting_date, "%Y-%m-%d") BETWEEN DATE_FORMAT(#{map.begin,jdbcType=VARCHAR}, "%Y-%m-%d") AND DATE_FORMAT(#{map.end,jdbcType=VARCHAR}, "%Y-%m-%d")
</if>
包含两端数据
只需要把and UNIX_TIMESTAMP(start_date) <= UNIX_TIMESTAMP(NOW())改为下面的语句即可
<![CDATA[and UNIX_TIMESTAMP(start_date) <= UNIX_TIMESTAMP(NOW())]]>
<![CDATA[ ]]> 强制转换小于等于