Hi. I have created a number of comments (Q & A) for another internal user and now I want to replace the author of the reply with the stakeholder of this post.
Q: How can I (bulk-) change the user of a comment ? In this case the reply.
Note: I changed it by using Quick Edit in Comments section to change Name and email, but the WPDiscusz name (@usercompany-com) in brackets behind the name still retains the old one.
@psi,
You can use the SQL code like this one:
UPDATE `wp_comments` SET `user_id` = 1 WHERE `comment_ID` = 86;
The wp_ is just a prefix in your case it can differ.
You'll need to change the red marked values.
Why do you want to change the user ID based on the comment ID ?
OK, change in the database. I don't want to replace all of the comments from user A to user B. Just the ones of a particular post (CPT), so I have to take the post id into the account as well.
