select records for day before yesterday mysql

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);