get yesterday's date in MySQL

How to Get Yesterday's Date in MySQL