/ Gists / Insert A Random String from List in MySQL
On gists

Insert A Random String from List in MySQL

MySql MySql tricks
Insert A Random String from List in MySQL

gistfile1.txt Raw #

UPDATE tablename 
SET columnname  = ELT(0.5 + RAND() * 6, 'value 1','value 2','value 3','value 4','value 5','value 6')