[MySQL] 하루, 일주일, 한달 기간 정하고 데이터 가져오는 query

 

하루

``` 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(); ```