MyBB Community Forums

How do i change a link in a thread with mysql

i have one like http://mybb.com

to

http://mybb1.com

how do you do something like that in all threads that the sentance appears in

is this in a signature, or in a ton of posts? im not sure i understand what your wanting to do. if in posts u can search through the tables in mysql for the string and replace them.

(2012-07-20, 02:08 AM)WebDevandPhoto Wrote: [ -> ]is this in a signature, or in a ton of posts? im not sure i understand what your wanting to do. if in posts u can search through the tables in mysql for the string and replace them.

Ok in a thread someone posts a link to a site eg http://mybb.com they changed the domain of that site so want to change the link on the thread how do u do it

http://vyaskn.tripod.com/search_all_colu...tables.htm
http://it.toolbox.com/wiki/index.php/Get...fied_Value
i got thinks links mate
they might help you with searching your db
regards
illusion

(2012-07-20, 02:16 AM)illusionalp Wrote: [ -> ]http://vyaskn.tripod.com/search_all_colu...tables.htm
http://it.toolbox.com/wiki/index.php/Get...fied_Value
i got thinks links mate
they might help you with searching your db
regards
illusion

I need the link replaced in my threads table.

(2012-07-20, 02:18 AM)xStefan Wrote: [ -> ]

(2012-07-20, 02:16 AM)illusionalp Wrote: [ -> ]http://vyaskn.tripod.com/search_all_colu...tables.htm
http://it.toolbox.com/wiki/index.php/Get...fied_Value
i got thinks links mate
they might help you with searching your db
regards
illusion

I need the link replaced in my threads table.

hmm try this mate
http://www.mssqltips.com/sqlservertip/16...ver-table/
http://beyondrelational.com/modules/2/bl...abase.aspx
http://stackoverflow.com/questions/59185...ns-of-a-db
regards
illusion

Create a word filter?

(2012-07-20, 02:25 AM)illusionalp Wrote: [ -> ]

(2012-07-20, 02:18 AM)xStefan Wrote: [ -> ]

(2012-07-20, 02:16 AM)illusionalp Wrote: [ -> ]http://vyaskn.tripod.com/search_all_colu...tables.htm
http://it.toolbox.com/wiki/index.php/Get...fied_Value
i got thinks links mate
they might help you with searching your db
regards
illusion

I need the link replaced in my threads table.

hmm try this mate
http://www.mssqltips.com/sqlservertip/16...ver-table/
http://beyondrelational.com/modules/2/bl...abase.aspx
http://stackoverflow.com/questions/59185...ns-of-a-db
regards
illusion

Your giving me stuff way to confusing it will must likely be a sql thing like FIND link IN MYBB_THREADS your giving me un-neccasary rescourses thanks anyway

(2012-07-20, 02:35 AM)xStefan Wrote: [ -> ]

(2012-07-20, 02:25 AM)illusionalp Wrote: [ -> ]

(2012-07-20, 02:18 AM)xStefan Wrote: [ -> ]

(2012-07-20, 02:16 AM)illusionalp Wrote: [ -> ]http://vyaskn.tripod.com/search_all_colu...tables.htm
http://it.toolbox.com/wiki/index.php/Get...fied_Value
i got thinks links mate
they might help you with searching your db
regards
illusion

I need the link replaced in my threads table.

hmm try this mate
http://www.mssqltips.com/sqlservertip/16...ver-table/
http://beyondrelational.com/modules/2/bl...abase.aspx
http://stackoverflow.com/questions/59185...ns-of-a-db
regards
illusion

Your giving me stuff way to confusing it will must likely be a sql thing like FIND link IN MYBB_THREADS your giving me un-neccasary rescourses thanks anyway

ok mate sorry for confusing you
i was just trying to help
regards
illusion

Still looking to solve this issue