MYSQL: Updating column with a random codified value

	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;

view raw mysql-update-case-random hosted with ❤ by GitHub