random number

[kjc]

How would I go about having arandom mixture of numbers/letters generated fromamysql database. I am writing a discussion board and want a random password generated for a colomn when i insert anew users details. Is this possible in mysql??

thanks

[kjc]

i just found out how to generate a random value in php - so will do it this way instead.