MySQL date functions

How to Get Yesterday's Date in MySQL