Categories : Database MySQL PHP 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) Posted on April 24, 2018