查询两个日期之前的日期内容的where语句
<if test="w.start != null and w.start != ''">AND checktime <![CDATA[>]]> #{w.start}</if> <if test="w.end != null and w.end != ''">AND checktime <![CDATA[<]]>#{w.end}</if>
查询某个字段的模糊查询
<if test="w.titles != null and w.titles !=''">and title LIKE CONCAT(CONCAT('%', #{w.titles}), '%') </if>