mysql update with random values from list 2014-10-28 19:57 Greg Stencel Comments “UPDATE book set year = ELT(1+FLOOR(RAND()*3), 2012,2013,2014)”