[MySQL] 하루, 일주일, 한 달 데이터 가져오기

📌 하루

SELECT * 
FROM TABLE_NAME 
WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 DAY) AND NOW();

 

📌 일주일

SELECT * 
FROM TABLE_NAME 
WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 WEEK) AND NOW();

 

📌 한 달

SELECT * 
FROM TABLE_NAME 
WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 MONTH) AND NOW();