Saturday 21 April 2018

How to get Yesterday's record data from MySQL Database?


SELECT * from product_order WHERE DATE(order_date) =  DATE(NOW() - INTERVAL 1 DAY)


By at
Labels: , ,

2 comments:

  1. John Smith25 January 2022 at 23:46

    This comment has been removed by the author.

    ReplyDelete
  2. John Smith6 May 2022 at 21:52

    This comment has been removed by the author.

    ReplyDelete

Subscribe to: Post Comments (Atom)