sub date mysql code example Example: mysql subdate SELECT SUBDATE(NOW(), INTERVAL 1 DAY); --Yesterday