MySQL NOW function

How to Get Yesterday's Date in MySQL