nix, shell, perl, php, mysql and mac os x tips and tricks

Tuesday, July 24, 2018

MySQL insert or update a random value from a set of given values

UPDATE my_table SET my_field = (SELECT sub.code FROM (SELECT '01' AS code
UNION SELECT '02'
UNION SELECT '53'
UNION SELECT '54'
UNION SELECT '55'
UNION SELECT '56') as sub
ORDER BY RAND() LIMIT 1)

No comments:

Post a Comment