Off the top of my head, I'd say use the
DATE_SUB(date,INTERVAL expression type) Function (see
manual page
http://www.mysql.com/doc/en/Date_and_time_functions.html
for details)
For example:
SELECT * FROM myTable WHERE date_field >=
DATE_SUB('2003-10-19', INTERVAL 7 DAY);
To get the records for th
How can I pull all records within a 1 week time frame? So if I enter
2003-10-19, how can I write a query that will get all records from
2003-10-12 - 2003-10-19.
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
