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. Link to comment https://forums.phpfreaks.com/topic/21734-search-and-replace/ 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 :-[ Link to comment https://forums.phpfreaks.com/topic/21734-search-and-replace/#findComment-97443 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. Link to comment https://forums.phpfreaks.com/topic/21734-search-and-replace/#findComment-97578 Share on other sites More sharing options...
fenway Posted September 25, 2006 Share Posted September 25, 2006 Is there an actual question here? Link to comment https://forums.phpfreaks.com/topic/21734-search-and-replace/#findComment-97939 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?" Link to comment https://forums.phpfreaks.com/topic/21734-search-and-replace/#findComment-97957 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. Link to comment https://forums.phpfreaks.com/topic/21734-search-and-replace/#findComment-97960 Share on other sites More sharing options...
Crusader Posted September 25, 2006 Author Share Posted September 25, 2006 Thanks. Never knew that existed. Link to comment https://forums.phpfreaks.com/topic/21734-search-and-replace/#findComment-97964 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.