MySQL yesterday date

How to Get Yesterday's Date in MySQL