Is there a way to batch change the time?

[runeveryday]

there are two columns as the following in my mysql database:

    ID        time
    1          2012-02-05 14:15:54
    2          2012-02-05 14:15:54
    3          2012-02-05 14:15:54
    4         2012-02-05 14:15:54
    5          2012-02-05 14:15:54
    10         2012-02-05 14:15:54

Now,i want to use a sql command(using in phpmyadmin) to update the time which is Optional in `(2011-01-05 14:15:54 ---2012-04-05 14:15:54)`


i want to change this `2012-02-05 14:15:54` to another time which is in `(2011-01-05 14:15:54 ---2012-04-05 14:15:54)` eg:`2011-02-06 13:15:54 2011-05-06 11:15:54....`

[r937]

could you repeat the question please?

i don't understand what eg:`2011-02-06 13:15:54 2011-05-06 11:15:54....` means

a column can hold only one value, it looks like you want to have a range?

[runeveryday]

generate a new time randly which between (2011-01-05 14:15:54 ---2012-04-05 14:15:54) then replace the old time in time column

[r937]

UPDATE daTable SET `time` = `time` + INTERVAL -30 + RAND(id)*90 DAY