mysql 有无函数能够使得左侧补零？

[netxuning]

具体应用如下语句

mysql> select CONV(3611120339,10,16);
+------------------------+
| CONV(3611120339,10,16) |
+------------------------+
| D73D52D3               |
+------------------------+
1 row in set (0.00 sec)

希望将输出的D73D52D3左侧自动补零凑足10位16进制数，缺几个就能自动补几个0，这样的要求如何能做到？

[rucypli]

mysql> select right(concat('00000',CONV(3611120339,10,16)),10); +--------------------------------------------------+ | right(concat('00000',CONV(3611120339,10,16)),10) | +--------------------------------------------------+ | 00D73D52D3 | +--------------------------------------------------+ 1 row in set (0.00 sec)