mysql subdate
snippet in sql

mysql subdate

user1187

SELECT SUBDATE(NOW(), INTERVAL 1 DAY);  --Yesterday