• Registered: 2005-02-01
  • Posts: 3

Topic: Global msg. search & replace somehow?

I have a user who needs to change a web address he used to link to all sorts of important stuff in our forum. He has made a lot of posts, so he doesn't want to go through and edit them all. Is there a way to automate this?

Thanks for any tips.

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Global msg. search & replace somehow?

UPDATE posts SET message = REPLACE(message, 'http://old_url_here/', 'http://new_url_here/');

I'd probably take a quick backup first though. I've never tried it myself smile

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • From: Montreal
  • Registered: 2006-10-02
  • Posts: 144

Re: Global msg. search & replace somehow?

Rickard wrote:

I'd probably take a quick backup first though. I've never tried it myself smile

It works alright  : )

Vanslyde's Website