PDA

View Full Version : Fins and replace


rooban12
10-12-2008, 06:05 AM
Hii There

Can anyone tell me how to change one word to another word [ for example change the word download to do not download] in all the threads in the forum in one go...

Thanks in advance:)

vBsquad
10-16-2008, 12:20 PM
Here's an example:

UPDATE user_table SET table_field = REPLACE(table_field, 'find_this',
'replace_with_this');

Keep in mind that it's not always as simple as that depending on the
script - with vBulletin you have to update various caches etc. Finally you need to replace the variables in that query first before running.

rooban12
10-16-2008, 02:58 PM
I will try this method
thanks vBsquad