How To Get Yesterday Records In MySQL?

Jan 29, 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