xxxxxxxxxx
INSERT INTO `im`
(`im`, `service`)
SELECT LOWER(`last`),
ELT(0.5 + RAND() * 6, 'AIM', 'ICQ', 'MSN', 'Yahoo', 'GTalk', 'Other')
FROM `contact`
xxxxxxxxxx
INSERT INTO `im` ( `im` , `service` )
SELECT LOWER( `last` ) , (
SELECT `service`
FROM `service`
ORDER BY RAND( )
LIMIT 1
)
FROM `contact`