change email of every wordpress user subscribed to a bbpress forum
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 “firstname.lastname@example.org”. I want to do something like:
UPDATE wp_users SET user_email = "email@example.com" WHERE wp_usermeta.meta_key = "participant";
- You must be logged in to reply to this topic.