The rand() function isn't available in all mysql versions so I have avoided it and select a random numbered row out of how ever many rows there are to select from. Lowering the number of required fields will give it a greater number to select from as Josh pointed out.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.