CODE EXAMPLE FOR SQL

how to get yesterday date in mysql

SELECT SUBDATE(NOW(),1);