SQL 语句：查询上个月到本月的记录

SELECT * FROM table_name AS a WHERE a.card_date > DATE_FORMAT(CURRENT_DATE - INTERVAL 1 MONTH, '%Y-%m-01') AND a.card_date < DATE_FORMAT(CURRENT_DATE, '%Y-%m-01')