Categories : Database MySQL PHP How to get Yesterday’s record data from MySQL Database? SELECT * from product_order WHERE DATE(order_date) = DATE(NOW() – INTERVAL 1 DAY) Posted on April 22, 2018