MySQL - how to use VARCHAR as AUTO INCREMENT Primary Key

you have to use an INT field
and translate it to whatever format you want at select time