====== Fetching records between two date ranges in MySQL ======

If you want to get rows between two dates in MySQL you would use a query like the following:\\

SELECT * FROM `sales_date` WHERE date_of_sale BETWEEN ‘2009-01-01′ AND ‘2009-01-21′\\

The between evaluates to 1 if sales date lines within the range of 2009-01-01 and 2009-01-21. If you wanted to fetch all rows not in the date range you could us NOT BETWEEN\\

For more information or support by phone for MySQL please call us at 410-838-5100 or email us at\\ [[experts@expertsinunix.com]]\\
[[http://www.skype.com|Skype]]: pts.support\\

{{keywords>fetching records between date ranges MySQL select where support phone }}