mybatis 怎么查询一个月 或者一周的数据

select * from dt_mb_records where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= record_time

在mysql里可以直接这样写 但是 用mybatis 怎么写 查询一个月的数据

> 将>号转义一下就可以

SELECT * from dt_mb_records where record_time >= DATE_SUB(NOW(),INTERVAL 1 MONTH)

<select id="findMbRecordsByUid" parameterType="int"
    resultMap="MbRecords">
    select * from dt_mb_records as t2 where
    t2.uid=#{uid} and SELECT * from dt_mb_records where record_time >= DATE_SUB(NOW(),INTERVAL 1 MONTH)
</select>
这样写不对呀

resultMap="MbRecords">
select * from dt_mb_records as t2 where
t2.uid=#{uid} and SELECT * from dt_mb_records where record_time >= DATE_SUB(NOW(),INTERVAL 1 MONTH)

mybatis有自己的大于和小于符号