How To Get Yesterday Records In MySQL?

MySQL

Nicesnippets

29-01-2022


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...