MySQL 将字符串类型字段值左侧补0

UPDATE f_draw_details SET draw_number = LPAD(draw_number, 2, '0') WHERE `level` in ('last2');
UPDATE f_draw_details SET draw_number = LPAD(draw_number, 3, '0') WHERE `level` in ('last3f','last3b','straight2','straight3','shuffle3');
UPDATE f_draw_details SET draw_number = LPAD(draw_number, 6, '0') WHERE `level` in ('first','second','third','fourth','fifth');
UPDATE f_draw_details SET draw_number = LPAD(draw_number, 12, '0') WHERE `level` in ('special');