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