UPDATE deltadb.transactions_temp SET ticker =(CASE CEIL(RAND()*2) WHEN 1 THEN '3CN:SP' WHEN 2 THEN 'AGV:SP' END);