mysql查詢最近三個月的記錄

<!--給前端查詢用-用於詳情頁右邊列表展示-->

<select id="getFrontProjectListRightShow" resultMap="ProjectResult">

SELECT project.id, project.name

FROM project

WHERE project.status != 4

AND project.show = 1

AND DATE_ADD(project.createTime,INTERVAL 3 MONTH) > NOW()

ORDER BY project.browseCount DESC

limit 10;

</select>

推薦閱讀：