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)
Tuesday, July 24, 2018
MySQL insert or update a random value from a set of given values
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment