Insert Random Words Into Column

[tomyknoker]

Hi all... I have a small members table in my db, one of the columns is called colour... Am wondering if there is any way I can insert randomly via some SQL typed into phpMyAdmin all different colours? SO basically I want to have 5 options, "grey", "green", "light blue", "red" & "orange"... And just want SQL to insert one of the colours for each member into their colour column... Anyone know of a way to do this? Not having much luck...

[mic2100]

you could looking into doing this with a stored procedure or function, unfortunately i have not worked with these directly so am unable to help you with them.