Limited Support
Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.
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.
