unique random alphanumeric in MySQL

[jrahma]

hi,

I want to know how can I created a unique random alphanumeric PIN in MySQL? I have job_order_code field and I want everytime to set a unique random alphanumeric code?

Thanks.

[bradgrafelman]

One option: UUID().