SQL

how to get yesterday date in mysql

SELECT SUBDATE(NOW(),1);

select records for day before yesterday mysql

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

mysql get yesterday

SELECT * FROM my_table WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 DAY)