SELECT SUBDATE(NOW(),1);
#Since yesterday
select * from orders where created_at > (CURDATE() - INTERVAL 1 DAY)
#the day before yesterday and yesterday
SELECT * from orders where created_at BETWEEN (CURDATE()- INTERVAL 2 DAY) AND (CURDATE()- INTERVAL 1 DAY);
SELECT * FROM my_table WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 DAY)