DATE_SUB MySQL

How to Get Yesterday's Date in MySQL