PHP - Moved: Need A Alternative To Order By Rand()

Really need a hand from someone mysql query is pretty basic.

I have been ask to add a random order to this query.

 $query = "SELECT rd.user_id
            FROM {$regions_data_table} rd
            WHERE rd.field_id = {$regions_field_id} AND rd.value LIKE %s
                  AND rd.user_id NOT IN (SELECT um.user_id
                                         FROM {$wpdb->base_prefix}usermeta um
                                         WHERE ((um.meta_key='wp_ul_disabled' AND um.meta_value=1) OR (um.meta_key='wp_ul_inactive' AND um.meta_value=1))
                                         GROUP BY um.user_id)";

I have tried so many options but cannot seem to get it to work i am trying to insert order by rand().

Any help please?

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=307671.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=355706.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=321790.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=347726.0