[MySQL] 오늘기준 - 하루/일주일/한달 최신 데이터 가져오기

하루
SELECT COLUMN1,2.... 
FROM TABLE 
WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 DAY ) AND NOW();

일주일
SELECT COLUMN1,2.... 
FROM TABLE 
WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 WEEK ) AND NOW();


한달
SELECT COLUMN1,2.... 
FROM TABLE 
WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 MONTH ) AND NOW();