Updating a column with a random codified value

mysql-update-case-random

update `datamart`.`mytable` 
set 
    mycolumn = case (FLOOR(1 + RAND() * 5))
        when 1 then 'SOME'
        when 2 then 'RANDOM'
        when 3 then 'STUFF'
		    when 4 then 'RIGHT'
		    when 5 then 'HERE'
end;

，，，