XF 1 Tip Mass Replacement of Thread Title

[ENXF NET]

LQD submitted a new resource:

Mass Replacement of Thread Title - for xenforo

This tips requires SQL query execution.
So for safety reason, you are advised to backup your database before doing this.

To remove some words from thread titles, and the threads are within certain nodes, you can run this SQL query from phpmyadmin :

Example :
Replace "viagra" into "medicine" from all thread title within nodes : 7, 8, 9, 10, 11.

UPDATE xf_thread
SET
title = REPLACE(title, 'viagra', 'medicine')
WHERE
node_id IN
(7, 8, 9, 10...

Read more about this resource...