• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Post Content Replacement Tool

DRE

Well-known member
#1
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...

postreplacement.jpg
 

Jake Bunce

XenForo moderator
Staff member
#2
You don't need a regex for that. Just use this query:

Code:
UPDATE xf_post
SET message = REPLACE(message, 'using Tapatalk', 'using Tapwater');
 
#4
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

XenForo developer
Staff member
#5
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 :)!
Code:
UPDATE xf_thread
SET title= REPLACE(title, 'using Tapatalk', 'using Tapwater');
That should do it :)
 
#7
@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...