Answers for "get last 2 weeks of data in mysql"

how to get data between a last week in mysql

SELECT id FROM tbl
WHERE date >= curdate() - INTERVAL DAYOFWEEK(curdate())+6 DAY
AND date < curdate() - INTERVAL DAYOFWEEK(curdate())-1 DAY

Posted by: Guest on May-25-2021

mysql get last 2 month data

SELECT * FROM d_jobs WHERE  `job_date` >= last_day(now()) + interval 1 day - interval 3 month;

Posted by: Guest on July-09-2020

Code answers related to "get last 2 weeks of data in mysql"