lpad(yourfield,(select length(max(yourfield)) FROM yourtable),'0') yourfield

这将获得表中的最大值并放置前导零.

如果是硬编码(PHP),请使用str_pad()

str_pad($yourvar,$numberofzeros,"0",STR_PAD_LEFT);

这是我在在线PHP编译器上所做的一个小例子,它有效……

$string = "Tutorial 1 how to";

$number = explode(" ",$string); //Divides the string in a array
$number = $number[1]; //The number is in the position 1 in the array,so this will be number variable

$str = ""; //The final number
if($number<10) $str .= "0"; //If the number is below 10,it will add a leading zero
$str .= $number; //Then,add the number

$string = str_replace($number,$str,$string); //Then,replace the old number with the new one on the string

echo $string;