Rand Order

[isimpledesign]

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?

[ManiacDan]

GROUP BY um.user_id) ORDER BY RAND()

-Dan