How can convert all posts that in category sport into news category by using SQL statement, Because i have more than 2000 posts
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
This should work*,
UPDATE wp_term_relationships SET term_taxonomy_id = '3' WHERE term_taxonomy_id = '1';
Where 1 is the id of the News category and 3 is the id of the Sports category
*You should back up your tables before making this change just in case something goes wrong.
