Inserting Multiple Random Rows

All,

I have a table of user addresses that I'm trying to randomly populate
with data from a cities table.  Using the following query:

INSERT INTO useraddrs(userid, addrdesc, city, stprov)
SELECT u.userid, 'Home', c.cityname, c.stateabbr
FROM users u, cities c
WHERE u.userid NOT IN (SELECT userid FROM useraddrs)   AND cid=(SELECT cid FROM cities ORDER BY RANDOM() LIMIT 1);

I am able to achieve most of what I am trying to accomplish, but once
the random number is selected, it doesn't change.  What am I missing?
Thank you in advance.

-- Gary Chambers

/* Nothing fancy and nothing Microsoft! */