Is there a way to batch change the time?

Databases
1

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....

2

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?

3

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

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