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.