Have you ever wanted to generate a random string in MySQL, say for assigning a random password to a list of users? Well here is a usefull tip!
SELECT SUBSTRING(MD5(RAND()) FROM 1 FOR 6) AS password
This creates a 6 charatcer (easy to change, as you can see) string where the characters are from the MD5 command (and therefore in the range a-z and 0-9).
Excellent tip - this would
Excellent tip - this would allow you to have a function for generating md5 keys for sessions instead of perl code... put it all in the db.
Thank for MYSQL random string
Thank for MYSQL random string generator help.
Really nice