HOW TO REPLACE SOME TEXT IN MYBB FORUMS POST & THREAD TOPICS

[netsat]

HOW TO REPLACE SOME TEXT IN MYBB FORUMS POST & THREAD TOPICS

Yes Friends
Some Text Words Which Are Illegal & Banned By Google..
I want to Replace all these Text Words In my forums post & thread topic name by one click !!!
Can its possible please help me!!!!

Other than word filter method?
bcz its just showing the changed word
but in actual word are still behind the filter words !!!
Its just showing not actual !!!

[.m.]

you have already seen a related topic and posted there.
as a precaution, I'd suggest to take a backup of database before attempting changes to database contents.

[netsat]

thank's dear for quick response !!!!!

UPDATE mybb_posts SET message = REPLACE(message,'OLD TEXT','NEW TEXT')

Can this code in also changed the possible changes in Thread Topic Name also...

[.m.]

^ no. that Query is for changing content of post messages only.
mybb_threads table consists of thread titles (subject). {I'll check it after power resumes}

[netsat]

ok dear i am waiting !!!!!!!!!

[.m.]

try this

UPDATE  `mybb_threads` SET  `subject` = REPLACE(`subject` , 'OLDword' , 'NEWword')

[netsat]

UPDATE mybb_posts SET message = REPLACE(message,'OLD TEXT','NEW TEXT')

When i apply that code
Error coming

#1146 - Table 'myserver_db.mybb_posts' doesn't exist

another time

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '**)' at line 1

[.m.]

what is the table prefix of your forum's database ? you have to replace mybb_ with the database tables prefix.

[netsat]

My database tables prefix is
_db

[.m.]

^ replace mybb_ with _db_ in the SQL queries