mysql查询当前日期的前一个月内的数据

SELECT * from alfresco.alf_restore where restore_time between (SELECT DATE_ADD(now(),INTERVAL -1 MONTH)) and now();