Hi, Thanks for the prompt reply. I have tested yours and it seems to be working. What about to group the result by week? TIA.
Willy Your life would be very empty if you had nothing to regret. -----Original Message----- From: Daevid Vincent <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Cc: sangprabv <[EMAIL PROTECTED]> Subject: Re: Query to Select records in the last 4 weeks Date: Wed, 03 Dec 2008 17:52:32 -0800 SELECT * FROM momtbak WHERE insertdate BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 4 WEEK) AND CURRENT_DATE(); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]