Update column with random string from list

PHOTO EMBED

Wed Apr 07 2021 13:17:21 GMT+0000 (Coordinated Universal Time)

Saved by @aymanelya #mysql

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