[TUT]Mass Replacement of Thread Title

[Sauron]

Sauron submitted a new resource:

Mass Replacement of Thread Title - Mass Replacement of Thread Title

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.

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

Read more about this resource...