How To Get Yesterday Records In MySQL?

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