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)))
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)))