How To Get Current Week Data In MySQL?

MySQL

Nicesnippets

28-01-2022


Hi Friends,

I am going to explain you example of how to get current week data in MySQL?. You will learn find current week data in SQL query. I would like to how to get data of current week only in MySQL.

This article will give you simple example of find data of current week in MySQL select statement. We will use get how to get data of current week only in MySQL server.

We will use MySQL query to get current week records.

Let's see bellow example:

Table : users


Solution SQL Query:

SELECT

*

FROM `users`

WHERE WEEK(created_at) = WEEK(now())

AND YEAR(created_at) = YEAR(now())

Output:

I hope it will help you...