SELECT CONCAT('#',LPAD(CONV(ROUND(RAND()*16777215),10,16),6,0)) AS color;


UPDATE `frm_staff` SET `profile_colour` = (SELECT CONCAT('#',LPAD(CONV(ROUND(RAND()*16777215),10,16),6,0)))