how to get data between a last week in mysql

Solutions on MaxInterview for how to get data between a last week in mysql by the best coders in the world

Search
showing results for - "how to get data between a last week in mysql"
Carmel
18 Oct 2017
1SELECT id FROM tbl
2WHERE date >= curdate() - INTERVAL DAYOFWEEK(curdate())+6 DAY
3AND date < curdate() - INTERVAL DAYOFWEEK(curdate())-1 DAY
4
source
similar questions
mysql date of the weekdate between in mysqlsql select data from last weekmysql get date diff in monthsselect amount weeks between two dates mysqlmysql between date rangemysql last 6 monthsmysql earlier than datemysql where one year agomysql date greater than 30 daysmysql 1 day agomysql last day of next monthselect row from mysql where date more than 30 daysmysql last friday of current monthmysql last yearmysql last 7 days including todaymysql 3 months agomysql get last 2 month datamysql one week agomysql date equals to current date plus daysmysql get last day of monthmysql get date difference in hoursthis week mysqlmysql date 1 daymysql get day of week
queries leading to this page
get last week date in mysqlhow to get last week data in mysqllast one week data in mysqlhow to get data between a last week in mysqlmysql how to get last week datahow to using between mysql query last weekmysql get week dates between dateshow to get data between a last week in mysql