[SQL] MySQL 하루, 일주일, 한달 데이터 조회하기

 

-- 하루
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();