mysql mybatis 查询7天内 30天内的信息

最新推荐文章于 2024-07-30 03:44:55 发布

微辣米粉

最新推荐文章于 2024-07-30 03:44:55 发布

阅读量1w

点赞数 2

分类专栏：【数据库】文章标签： mybatis mysql

本文链接：https://blog.csdn.net/tuntun1120/article/details/73603511

版权

【数据库】专栏收录该内容

23 篇文章 1 订阅

订阅专栏

<select id="queryWithPageByParam" resultMap="ResultMapWithBLOBs"  parameterType="ActionValues" >
  select
  <include refid="Base_Column_List" />
  ,
  <include refid="Blob_Column_List" />
  from TABLE_NAME
  <if test="sort == null or sort == ''">
    order by CREATE_TIME DESC
  </if>
  <if test='sort == "new" '>
    order by CREATE_TIME DESC
  </if>
  <if test='sort == "hot" '>
    and DATE_SUB(CURDATE(), INTERVAL 30 DAY) <![CDATA[<=date(CREATE_TIME)]]>
    order by LIKES DESC , NUM DESC , CREATE_TIME DESC
  </if>

</select>