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 This Week's (Monday to Sunday) record data from MySQL Database?

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())