UPDATE multiple rows with random values from array?

SQL++
2

Hi @R3ason ,

Inline the variable

UPDATE vehicle SET color=['Red', 'Blue', 'Yellow'][FLOOR(RANDOM() * 3)]
WHERE vehicle_stage='paint'

OR

UPDATE vehicle SET color= CASE FLOOR(RANDOM()*3) WHEN 0 THEN "RED" WHEN 1 THEN "BLUE" ELSE "YELLOW" END
WHERE vehicle_stage='paint'

MB-47277