mysql - 将前导零添加到数字

Question

我想知道是否有一种方法可以在选择少于 4 个字符并转换为字符串时向数字添加前导零。

我很感激任何建议，提前致谢!

类似于:

SELECT PAD(CAST(last4 as string), 4) as last4 from numbers

期望的输出:

1 => 0001
100 => 0100
112 => 0112
15 => 0015

Answer 1

你离得很近:

SELECT LPAD(last4, 4, '0') as last4 FROM numbers;

参见 https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_lpad