help with wordpress - mass change of links

[klinton]

I have few hundreds posts in wordpress site. Each post has some link url which is like

http://aa.com/hereisvariable

, and I would like to mass change all of these urls to

http://newurl.com

how to do that ? I try to play with search regex plugin, but how no idea how to do that task....

[j3rkules]

The next time you can use an affiliate link cloaking plugin so you do not need to change the link in all posts manually.

Here what you can do:

1. Download your wordpress database and saved it as a backup.

2. Copy the backup to another location and opened it in a text editor (text wrangler in my case).

3. Search for the old link, then used the 'replace all' command to replace it with the new one. It found several thousand instances of the old link and replaced them all.

4. In PHPmyAdmin, drop all the tables then import the modified database file. All of the links will be fixed.

[wehateporn]

How to Perform Mass Search and Replace in Wordpress - Hongkiat

[Denny]

https://cs.wordpress.org/plugins/search-and-replace/

[klinton]

no idea how to use it correctly, as the urls that I need to change are on the same domain, but later they change, like

http://steadydomain.com/butnewurleverytime

Originally Posted by Denny

https://cs.wordpress.org/plugins/search-and-replace/

[wehateporn]

[klinton]

so how to mark that I need to remove all links from domain xxx.com while these links will be like xxx.com/1link, xxx.com/2link , xxx.com/whateverlink and so on ?

Originally Posted by wehateporn

[wehateporn]

Originally Posted by klinton

so how to mark that I need to remove all links from domain xxx.com while these links will be like xxx.com/1link, xxx.com/2link , xxx.com/whateverlink and so on ?

Just read your question properly, I'm guessing it's using the % wildcard, xxx.com%, but this is not my thing, so best wait for someone who knows this stuff to appear

[klinton]

yeah, who would expect that... the guy that spams board with some conspiracy shit stories would have problem with comprehending text...

anyway, I found solution using php delimiters and search regex plugin.
php delimiter to url link is

/<a [^>]+>/i

Originally Posted by wehateporn

Just read your question properly, I'm guessing it's using the % wildcard, xxx.com%, but this is not my thing, so best wait for someone who knows this stuff to appear

[wehateporn]

Originally Posted by klinton

yeah, who would expect that... the guy that spams board with some conspiracy shit stories would have problem with comprehending text...

anyway, I found solution using php delimiters and search regex plugin.
php delimiter to url link is

/<a [^>]+>/i

I didn't sleep well last night, but yes I do find conspiracies more interesting than SQL and I have started skimming a bit too much on GFY

Glad you got a solution

[j3rkules]

Originally Posted by klinton

so how to mark that I need to remove all links from domain xxx.com while these links will be like xxx.com/1link, xxx.com/2link , xxx.com/whateverlink and so on ?

Item to replace "http://aa.com/hereisvariable" to "http://newurl.com"

I am bit late... it seems that you have found a solution.