Jump to content

Archived

This topic is now archived and is closed to further replies.

Crusader

search and replace?

Recommended Posts

Is there an easy way to do a "search and replace" in MySql? The data I need to alter is stored in a longtext/possibly blob. I basically need to replace all instances of one word. Any ideas?

Thanks.

Share this post


Link to post
Share on other sites
I have an idea that you're going to be up all night  :-[

Share this post


Link to post
Share on other sites
:(

There was a big problem with the ' character showing up as a bunch of gibberish... I don't think I can look through 200 news posts in time.

Share this post


Link to post
Share on other sites
Is there an actual question here?

Share this post


Link to post
Share on other sites
[quote author=fenway link=topic=109139.msg440665#msg440665 date=1159156350]
Is there an actual question here?
[/quote]

"Is there an easy way to do a "search and replace" in MySql? The data I need to alter is stored in a longtext/possibly blob. I basically need to replace all instances of one word. Any ideas?"

Share this post


Link to post
Share on other sites
Well, there is a REPLACE() function, so yes.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.