Post Content Replacement Tool

[DRE]

Hi. I'm using Kier's Post Content Replacement Tool that uses Search / Replace.

How do I replace the following phrase: using Tapatalk

with a custom phrase such as: using Tapwater

Just an example...

 

[Jake Bunce]

You don't need a regex for that. Just use this query:

UPDATE xf_post
SET message = REPLACE(message, 'using Tapatalk', 'using Tapwater');

 

[DRE]

Thank you Based Bunce Da Gawd

 

[badlands]

Hey Jake,

awesome - do you also have the SQL-Query for changing single words in Thread Titles? I guess you only have to change the "xf_post" to another expression. Thanks !

 

[Chris D]

Hey Jake,

awesome - do you also have the SQL-Query for changing single words in Thread Titles? I guess you only have to change the "xf_post" to another expression. Thanks !

UPDATE xf_thread
SET title= REPLACE(title, 'using Tapatalk', 'using Tapwater');

That should do it

 

[badlands]

Thanks, Chris!

 

[badlands]

@Jake: When I ran your query with the goal to replace "RL" with "Ralph Lauren" it also changed "URL" to "URalph Lauren". Is there a way to only change words with a Space in front and behind them to avoid this? Thanks for an Update...

 

[Chris D]

UPDATE xf_thread
SET title= REPLACE(title, ' RL ', ' Ralph Lauren ');

Put spaces before and after what you're searching for (and its replacement).

 

[badlands]

Thanks again!! So easy

 

[fionix]

do you know how I can replace http://www.domain1.com/something/something to http://www.domain1.com ?

 

[dougdirac]

What if the text you want to replace includes a quotation mark?