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 useful tip!
[adsense:468x60:4496506397]
SELECT SUBSTRING(MD5(RAND()) FROM 1 FOR 6) AS password
This creates a 6 character (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).
[adsense:468x60:4496506397]