Fetch Record of last week and last month

[Avani_Bhatt]

How to fetch the records which are posted during last week and last month?

[Avani_Bhatt]

Query for Last Week : SELECT * FROM `tblname` WHERE `datecolumn` >= DATE_SUB(DATE_SUB(CURDATE(),INTERVAL 7 DAY),INTERVAL WEEKDAY(DATE_SUB(CURDATE(),INTERVAL 7 DAY)) DAY) AND `datecolumn` <= DATE_ADD( DATE_SUB( CURDATE( ) , INTERVAL 7
DAY ) , INTERVAL( 7 - ( WEEKDAY( DATE_SUB( CURDATE( ) , INTERVAL 7
DAY ) ) +1 ) )
DAY )

Query for Last Month : SELECT * FROM `tblname` WHERE `datecolumn` >= DATE_SUB( DATE_SUB( CURDATE( ) , INTERVAL 1 MONTH ) , INTERVAL DAYOFMONTH( DATE_SUB( CURDATE() , INTERVAL 1
MONTH )-1 ) DAY ) AND `datecolumn` <= LAST_DAY( DATE_SUB( CURDATE( ) , INTERVAL 1
MONTH ) )