20.6 C
New York
Saturday, August 13, 2022

How to fetch this week records in MySql ?

- Advertisement -





If you require to get all the records of current week using mysql query. for example you have one table “items” and columns are id, title, description, created_at and update_at, Now you want to get all records of this week. so you can fetch fields value using DATE_SUB and INTERVAL of mysql. In following example you can see how to select data of current week.

Example

SELECT * FROM items WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 WEEK);

- Advertisement -

Related Articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest Articles