How to get the week wise result from the table?
Below are the list of sql query to retrieve the data from mysql about current week,previous week,next week,forthcoming weeks from current week.Its very easy to handle.
To get Previous Week:
1.SELECT * FROM tablename WHERE YEARWEEK(DATE_SUB(CURDATE(),INTERVAL 7 day))=YEARWEEK(birthdate)
1.SELECT * FROM tablename WHERE YEARWEEK(CURDATE())=YEARWEEK(deliverydate)
2.SELECT * FROM tablename WHERE YEARWEEK(DATE_ADD(CURDATE(),INTERVAL 0 day))=YEARWEEK(birthdate)
To get Next Week:
1.SELECT * FROM tablename WHERE YEARWEEK(DATE_ADD(CURDATE(),INTERVAL 7 day))=YEARWEEK(birthdate)
To get 2nd week from current week:
1.SELECT * FROM tablename WHERE YEARWEEK(DATE_ADD(CURDATE(),INTERVAL 14 day))=YEARWEEK(birthdate)
To get 3rd week from current week:
1.SELECT * FROM tablename WHERE YEARWEEK(DATE_ADD(CURDATE(),INTERVAL 21 day))=YEARWEEK(birthdate)