레퍼런스 마이닝

-- 하루 SELECT COLUMN1 , COLUMN2 , COLUMN3 , .... FROM TABLE WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(), INTERVAL -1 DAY) AND NOW(); -- 일주일 SELECT COLUMN1 , COLUMN2 , COLUMN3 , .... FROM TABLE WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(), INTERVAL -1 WEEK) AND NOW(); -- 한달 SELECT COLUMN1 , COLUMN2 , COLUMN3 , .... FROM TABLE WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(), INTERVAL -1 MONTH) AND NOW();