MyBB Community Forums

their is no

mybb_posts 

in there

their is only

mybb_tablesposts

&

mybb_tablesreportedposts

---

(2013-05-19, 07:13 PM).m. Wrote: [ -> ]^ 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**')

---

(2013-05-16, 12:12 PM).m. Wrote: [ -> ]try this

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

Great This Method Working Fine

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.