Update all "post_name" and "guid" by the new title..

  • Hey guys,

    I’m looking for a plugin to update all the post_name and guid fields inside my db with the information the post title gives me at this moment..

    So if I post a new article and call it “Any Kind Of Title” and going to rename it to “Another Cool Title” the slug are still any-kind-of-title … and so I’m looking for a way to keep all the slugs are up2date.. ??

    And Ideas? (except doing it by hand for every article… ;))

Viewing 1 replies (of 1 total)

  • Not sure if this is what you are looking for, but .. hopefully this can fix it.

    You can do a bulk update (by hand) on your wp_posts table.

    UPDATE wp_posts set guid=replace(guid,”https://previous.domain/”, “https://new.domain”);

    UPDATE wp_posts set post_name=replace(post_name,”old-string”, “new-string”);

    WARNING: Since this is a BULK-NON-UNDOABLE update … you MUST back up your data before executing any bulk changes.
    Please take care on this so I am not responsible for any mistakes or unexpected results.

    Regards and success,
    —
    jjy

Viewing 1 replies (of 1 total)
  • The topic ‘Update all "post_name" and "guid" by the new title..’ is closed to new replies.