I have a table that has a datetime field that gets set every time data gets entered in the table (for example "2004-05-16 19:08:59"). How can I select all entries that were entered one year ago today. And, how can I select entries that were entered one year ago today +7 days.
So, if today being 2004-05-16, -> I want to select all entries dated 2003-05-16 -> And I also want entries dated between 2003-05-16 and 2003-05-23
--
H| I haven't lost my mind; it's backed up on tape somewhere.
+--------------------------------------------------------------------
Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130
IT Director / SysAdmin / WebSmith . 800.441.3873 x130
Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6
http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
