Bulk moving old posts to new language
-
Hello
I have a blog with 70000 posts. The default language of all posts is UK. I want to move all old posts to RU locale using SQL
Here is what I do to select all old posts:
SELECT * FROM wp_posts WHERE post_date<'2022-07-17' AND post_type = 'post' ORDER BY wp_posts.post_date DESC
I found here to find posts by language https://stackoverflow.com/a/63131500/3197180:
SELECT * FROM wp_posts WHERE post_status = 'publish' AND ID IN ( SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(description, '"uk";i:', -1), ';',1) FROM
wp_term_taxonomy
WHEREtaxonomy
= 'post_translations' ) order by ID descBut I see only homepage, because it’s only one by connected by language
The question is: how can I select all old posts and change the language?
Thanks
- The topic ‘Bulk moving old posts to new language’ is closed to new replies.