SELECT * from product_order WHERE YEAR(order_date) = YEAR(CURRENT_DATE – INTERVAL 1 MONTH) and MONTH(order_date) = MONTH(CURRENT_DATE – INTERVAL 1 MONTH)
How to get This Month’s record data from MySQL Database?
SELECT * from product_order WHERE MONTH(order_date) = MONTH(NOW()) and YEAR(order_date) = YEAR(NOW())
How to get Last Week’s (Monday to Sunday) record data from MySQL Database?
SELECT * from product_order WHERE yearweek((order_date), 1) = yearweek(curdate(), 0)
How to get Yesterday’s record data from MySQL Database?
SELECT * from product_order WHERE DATE(order_date) = DATE(NOW() – INTERVAL 1 DAY)
How to get Today’s record data from MySQL Database?
SELECT * from product_order WHERE DATE(order_date) = DATE(NOW())