Search and Replace

[WoodiE]

I'm looking for either a built-in function or add-on that will search for a certain phrase or sentence that is posted within all posts made either on the forum as a whole or by an individual user and then replace it with something else... in this particular case, delete it.

Any suggestions?

[Disco_Dave]

ACP > Styles & Templates > Replacement Variables

HTH

[WoodiE]

I'd much rather remove the entire line from the forum instead of that method if possible.

Is there a query of some sort I can run? If not then I'll surrender to Replacement Variables.

[exel]

Check this out:

https://vborg.vbsupport.ru/showpost.php?p=2435276&postcount=4

[WoodiE]

Exactly what I'm looking for, thank you very much.

Ended up going a step further by limiting the search and replace to one user:


UPDATE
rc_post
SET
pagetext = replace(pagetext,'TEXT TO REPLACE', 'NEW TEXT')
WHERE
userid = 'xxx'