I am currently working on a project that requires me to have an order number that has an input mask that look like this 'XXX-XXXX-XXX' and this will be a unique number. I would like to know if mysql supports input masks or if i'd have to set it up from my php script and if so, how will I create it there?