[haddly]

Hi there,
I want to do a test mailing in my staging area, to see if a new WP plugin works for BBpress. In order to do this, i want to change all emails to my personal email address for all that are subscribed to the forum (so i don’t accidentally send out mails to real users,(this has actually happened to me before)). The problem is that the WP user_email is found in the DB wp_users and the forum meta info is found in the DB wp_usermeta. What SQL statement would i use if i wanted to change the email of all bbpress “Participants” to “myemail@email.com”. I want to do something like:
UPDATE wp_users SET user_email = "myemail@email.com" WHERE wp_usermeta.meta_key = "participant";

[haddly]

so, with some help from a collegue, this is how to do it:

update wp_users  
    set wp_users.user_email = "myemail@email.com"
    where
    wp_users.ID IN (
    select  
    wp_usermeta.user_id
    from wp_usermeta
    where (wp_usermeta.meta_key = "wp_capabilities") &&  (wp_usermeta.meta_value like 
    "%bbp_participant%")   
    )
    ;

[haddly]

advice here would be to do a dump of the wp_users.user_email before doing such a job, as there are no backsies……