Insert Into Table Using Field Criteria

[vinic]

This seems like it would be a straightforward function, but after searching all morning I'm a bit stuck.

Into an exsiting db, I'd like to update a field (called "week") in rows with certain dates (listed in another field called "time"). The table is called "digi".

Here's what I tried, but it appears that this should be pulling the data from a second table. Is ther a way to send the data, in this case very simple "3" to the rows with specific dates?

INSERT INTO digi SET week='3' WHERE time BETWEEN '2008-01-14 00:00:04' AND '2008-01-16 02:40:04';

Any guidence would be greatly appreciated.

[vinic]

This seems like it would be a straightforward function, but after searching all morning I'm a bit stuck.

Into an exsiting db, I'd like to update a field (called "week") in rows with certain dates (listed in another field called "time"). The table is called "digi".

Here's what I tried, but it appears that this should be pulling the data from a second table. Is ther a way to send the data, in this case very simple "3" to the rows with specific dates?

INSERT INTO digi SET week='3' WHERE time BETWEEN '2008-01-14 00:00:04' AND '2008-01-16 02:40:04';

Any guidence would be greatly appreciated.

Sorted this on my own. Found the update function could do this:

UPDATE digi SET week=3 WHERE time BETWEEN '2008-01-14 00:00:04' AND '2008-01-16 02:40:04';

Sorry to take up space..... maybe this'll help another noob sometime.
(or me, when I'm looking for the same answer next year!)

Offward!!! UnChristian Soldiers.