input mask for field in mysql db

[gogirl]

Hello kind and intelligent person

I would like to put an input mask on a field in my mysql database so that when a user enters a number like 55 it will automatically add the zeros in front.
(i.e. 55 -> 000055)

How can this be done?

Thanks,

gogirl

 

[sleipnir214]

MySQL won't do that.

The the authors of MySQL have made a point of simplifying their developement efforts by reducing the number of functions the server provides (compared to other database servers). A big part of their methodology seems to be that anything which is a display format issue is best handled in whatever programming language your user interface is using.

Your requirement seems to fall in that category. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!