select * from table_name where (date between DATE_ADD(LAST_DAY(DATE_SUB(CURDATE(), interval 30 day), interval 1 day) AND CURDATE() )
或更好 ：
select * from table_name where (date between DATE_FORMAT(NOW() ,'%Y-%m-01') AND NOW() )
select * from table_name where (date between DATE_ADD(LAST_DAY(DATE_SUB(CURDATE(), interval 30 day), interval 1 day) AND CURDATE() )
或更好 ：
select * from table_name where (date between DATE_FORMAT(NOW() ,'%Y-%m-01') AND NOW() )
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
