Previous date

[nikko50]

How do I get the previous date.

SELECT CURRENT_DATE();

[NogDog]

SELECT DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)