从上个月的sql中选择数据

Question

I have this code to select from my database data from current month:

SELECT * FROM daily_reports
WHERE username = '$username' and MONTH(date) = MONTH(Now())
order by date DESC

And now i want to display data from last month.

column date is type date

Answer 1

This should work:-

SELECT *
 FROM daily_reports 
WHERE username = '$username' 
and MONTH(date) = MONTH(DATE_ADD(Now(), INTERVAL -1 MONTH))
 order by date DESC