XF 2.1 Replace text directly from database


Active member
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 .
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 ** :)
Top Bottom