Question : sql select data from last week
Answered by : procoder
select id from tbname
where date between date_sub(now(),INTERVAL 1 WEEK) and now();
Source : | Last Update : Fri, 07 Aug 20
Question : sql select data from last week
Answered by : mongezi
select id from tbname
where date between date_sub(now(),INTERVAL 1 WEEK) and now();
Source : https://stackoverflow.com/questions/6089960/mysql-query-to-select-data-from-last-week | Last Update : Tue, 14 Apr 20