# DataBase/Mysql(MariaDB)2022. 4. 28. 18:02mysql 현재 기준 한달이전 확인 쿼리
SELECT count(*) FROM [table] WHERE [date_colum]
# DataBase/Mysql(MariaDB)2021. 9. 9. 17:44mysql 기간별 select query(현재기준)
현재 기준 하루/일주일/한달 select 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();