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

[netsat]

their is no

mybb_posts 

in there

their is only

mybb_tablesposts

&

mybb_tablesreportedposts

---

^ replace mybb_ with _db_ in the SQL queries

Error

My Code Is

UPDATE _db_posts SET message = REPLACE(message,'Key','K**')

Error
#1146 - Table '_db._db_posts' doesn't exist

---

Finally After many Changes I get success

UPDATE mybb_tablesposts SET message = REPLACE(message,'Key','K**')

---

try this

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

Great This Method Working Fine

[rock.cruze]

Hi .m.,
You made my day.
I am going to sleep well today

replaced 1300+ bad adfly links in less than 2 seconds

Thanks for the wonderful tip and thanks netsat for posting the question.