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