29-Jan-2022
.
Admin
Hi Friends,
I am going to explain you example of how to get yesterday records in MySQL?. You will learn get yesterday records in MySQL. I would like get yesterday records in SQL query result.
We will use get search get yesterday records in MySQL. You can understand a concept of find yesterday date in MySQL. So, we can find yesterday's date in MySQL example.
Let's see bellow example:
Table : users
Solution SQL Query:
SELECT
*
FROM `users`
WHERE DATE(created_at) = SUBDATE(CURDATE(),1)
Output:
I hope it will help you...
#MySQL