I need to assign posts of Author A to Author B
I ran a query
UPDATE wp_posts SET post_author=NEW_AUTHOR_ID WHERE post_author=OLD_AUTHOR_ID;
and it changed the authorid in the wp_posts table. But the posts still continue to show the old author on the post and in the coauthors selection. How do I change the coauthors data?