XF 2.1 Replace text directly from database

[cosmin85]

Hi ,

Any usefull query to change some text from threads directly from database (via phpmyadmin) ?

eg. change textABC to ABC123 .

I know that exists an addon (find and replace) but i dont understand it at all .
Thanks.

 

[Paul B]

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

 

[Gene Steinberg]

How about resource descriptions in Resource Manager?

 

[Gri]

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

Hi @Brogan, is it possible to delete something spesific? For example I'd like to remove ABC123 text from all messages?

 

[Kruzya]

@Gri, just leave new_content as empty:

UPDATE xf_post SET message = REPLACE(message, 'ABC123', '');

 

[Gri]

@Gri, just leave new_content as empty:

UPDATE xf_post SET message = REPLACE(message, 'ABC123', '');

Thank you very much @Kruzya

 

[Gri]

I'm trying to remove this adsense code from posts. When I run this code, nothing happens, it says "0 rows affected".

UPDATE xf_post SET message = REPLACE(message, '<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-*****************" crossorigin="anonymous"></script>', '');

Note: I -of course- replaced real adsense id with **

 

[Kruzya]

How you inserted AdSense code?
HTML cannot be used by default in messages.

 

[Gri]

How you inserted AdSense code?
HTML cannot be used by default in messages.

With this add-on:

Parse HTML

Allow users with permission to post parsed HTML content.

nixfifty.com