change email of every wordpress user subscribed to a bbpress forum
up vote
0
down vote
favorite
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).
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";
mysql wordpress bbpress
asked Nov 12 at 17:31
Haddly
218
add a comment |
up vote
0
down vote
favorite
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).
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";
mysql wordpress bbpress
asked Nov 12 at 17:31
Haddly
218
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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).
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";
mysql wordpress bbpress
asked Nov 12 at 17:31
Haddly
218
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).
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";
mysql wordpress bbpress
mysql wordpress bbpress
asked Nov 12 at 17:31
Haddly
218
asked Nov 12 at 17:31
Haddly
218
edited Nov 12 at 17:58
asked Nov 12 at 17:31
Haddly
218
asked Nov 12 at 17:31
Haddly
218
asked Nov 12 at 17:31
Haddly
218
218
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
With help from a collegue, this is the solution:
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%")
)
;
answered Nov 14 at 12:28
Haddly
218
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
With help from a collegue, this is the solution:
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%")
)
;
answered Nov 14 at 12:28
Haddly
218
add a comment |
up vote
0
down vote
With help from a collegue, this is the solution:
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%")
)
;
answered Nov 14 at 12:28
Haddly
218
add a comment |
up vote
0
down vote
up vote
0
down vote
With help from a collegue, this is the solution:
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%")
)
;
answered Nov 14 at 12:28
Haddly
218
With help from a collegue, this is the solution:
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%")
)
;
answered Nov 14 at 12:28
Haddly
218
answered Nov 14 at 12:28
Haddly
218
answered Nov 14 at 12:28
Haddly
218
answered Nov 14 at 12:28
Haddly
218
218
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53267264%2fchange-email-of-every-wordpress-user-subscribed-to-a-bbpress-forum%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
