update `dle_post` set `date`= str_to_date( concat( floor(1 + rand() * (12-1)), /* Generate a random month */ '-', floor(1 + rand() * (28 -1)), /* Generate a random day */ '-', '2012' ), '%m-%d-%Y' )
update `dle_post` set `date`= str_to_date( concat( floor(1 + rand() * (12-1)), /* Generate a random month */ '-', floor(1 + rand() * (28 -1)), /* Generate a random day */ '-', '2012' ), '%m-%d-%Y' )