PDA

View Full Version : database replace a word


bollie
11-25-2008, 06:10 PM
I would in my database to replace a word that appears ,1000 times. The word is forum and should be replaced by the forumske . How can I do this?

UKBusinessLive
11-25-2008, 07:11 PM
Run a query like this on your database


UPDATE post
SET pagetext = REPLACE(pagetext,'FORUM','FORUMSKE')


Good Luck

bollie
11-26-2008, 01:58 PM
Work not for url's

Lynne
11-26-2008, 02:22 PM
If you want more help, you should post the exact query you tried to run and then perhaps we can see what your error was.