SELECT * FROM table
WHERE YEAR(date_created) = YEAR(CURRENT_DATE – INTERVAL 1 MONTH)
AND MONTH(date_created) = MONTH(CURRENT_DATE – INTERVAL 1 MONTH)

By admin

Leave a Reply

Your email address will not be published. Required fields are marked *