MySQL dynamic dates

How to Get Yesterday's Date in MySQL