Mass edit url in blog posts on wordpress?

[marktruman]

So I have a ton of wordpress blogs, With a shitload of posts. Is there anyway to edit the url in them blog posts? I will be changing it to the same url. I think I heard of a way in phpmyadmin

[WarChild]

You want to change all occurrences of a single URL to a single new URL or you want to change multiple different URLS to be one new one?

[TheDoc]

UPDATE wp_posts SET post_content = replace(post_content, "/replace-this/", "/with-this/");

[marktruman]

Originally Posted by WarChild

You want to change all occurrences of a single URL to a single new URL or you want to change multiple different URLS to be one new one?

Single URL to a different Single URL

[marktruman]

Originally Posted by TheDoc

UPDATE wp_posts SET post_content = replace(post_content, "/replace-this/", "/with-this/");

is that a command, where is that entered?

[WarChild]

Originally Posted by marktruman

is that a command, where is that entered?

That's an SQL statement to update your database that drives yoru blog at the database level. You must have access to your MySQLServer, correct?

[alias]

Originally Posted by TheDoc

UPDATE wp_posts SET post_content = replace(post_content, "/replace-this/", "/with-this/");

Nice.

[TheDoc]

Originally Posted by marktruman

is that a command, where is that entered?

If you're unsure what that is, it's best to ask your host to run it for you.... just tell them exactly what you want found and replaced and most hosts will gladly do it for you.

Otherwise, enter php my admin, access the wp db, hit the post table, click the SQL tab at the top, and enter that line.... after you change out what to replace. Your wp_posts table may be named differently.

UPDATE wp_posts SET post_content = replace(post_content, "www.oldurl.com", "newurl.com");

Screwing this up though can really screw some shit up... the last tab at the top, whatever it is, will let you duplicate the post table & structure to a new table name - highly recommended doing this if you've never ran a command like this before.

[TheDA]

There's a way to do it from WP with a plug-in as well.

http://lesterchan.net/portfolio/programming/php/ The DB manager there lets you edit SQL at that level.

It also lets you backup your database before you do it in case you fuck it up

[TheDoc]

Originally Posted by alias

Nice.

Thanks... I just moved a ton of sites to multisite, so the line is fresh on the brain.

If you move to multisite from a standalone wp, you've gota run that to replace the content paths.

[Paul&John]

http://downloads.wordpress.org/plugi...nd-replace.zip