Find and replace

[Lee]

Morning.

I am looking for a way to carry out a find replace on the posts table of the database.

I want to search all posts for all instances of "url1.net" and replace them with "url2.net".

Is this a simple query to run?

 

[Paul B]

Take a backup first.

UPDATE xf_post SET message = REPLACE(message, 'http://www.old.com', 'https://new.co.uk');

 

[MySiteGuy]

Morning.

I am looking for a way to carry out a find replace on the posts table of the database.

I want to search all posts for all instances of "url1.net" and replace them with "url2.net".

Is this a simple query to run?

There's an addon for this:

Post Content Find / Replace

This is a direct port of the original Post Content Find / Replace add-on for XF 1.x. You may wish to search the original resource discussion for solutions to common tasks performed with this add-on.

xenforo.com

It uses regular expressions for matching and replacing. If you're unfamiliar with those, this is a good site for testing:

regex101: build, test, and debug regex

Regular expression tester with syntax highlighting, explanation, cheat sheet for PHP/PCRE, Python, GO, JavaScript, Java, C#/.NET, Rust.

regex101.com

 

[Lee]

Thanks Both.