Answers for "mysql get yesterday records"

SQL
1

how to get yesterday date in mysql

SELECT SUBDATE(NOW(),1);
Posted by: Guest on August-05-2020
5

mysql get yesterday

SELECT * FROM my_table WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 DAY)
Posted by: Guest on February-26-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language