# DBでIDからランダム風文字列を生成するアイデア ```sql SELECT LOWER(HEX(CAST(CONCAT('1', REVERSE(id), '0') AS SIGNED))) AS code FROM table_name; ``` ```sql UPDATE table_name t1 SET code = (SELECT LOWER(HEX(CAST(CONCAT(CONCAT('1', REVERSE(t2.id)), '0') AS SIGNED))) AS code FROM table_name t2 WHERE t1.id = t2.id); ```