Crusader Posted September 22, 2006 Share Posted September 22, 2006 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. Quote Link to comment Share on other sites More sharing options...
Lee Posted September 24, 2006 Share Posted September 24, 2006 I have an idea that you're going to be up all night :-[ Quote Link to comment Share on other sites More sharing options...
Crusader Posted September 24, 2006 Author Share Posted September 24, 2006 :(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. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 25, 2006 Share Posted September 25, 2006 Is there an actual question here? Quote Link to comment Share on other sites More sharing options...
Crusader Posted September 25, 2006 Author Share Posted September 25, 2006 [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?" Quote Link to comment Share on other sites More sharing options...
fenway Posted September 25, 2006 Share Posted September 25, 2006 Well, there is a REPLACE() function, so yes. Quote Link to comment Share on other sites More sharing options...
Crusader Posted September 25, 2006 Author Share Posted September 25, 2006 Thanks. Never knew that existed. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.