• 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 WHERE taxonomy = 'post_translations' ) order by ID desc

    But 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.