KingOfHeart Posted February 6, 2011 Share Posted February 6, 2011 I have a bunch of Links in my "Downloads" table in the "link" field. I want to search all links that start with "http://openzelda.thegaminguniverse.com" and change it to http://openzelda.thegaminguniverse.org I know how to change a rows information but not completly sure on how to change part of the information. I got at least 50 rows to change so I don't want to goof this up. Link to comment https://forums.phpfreaks.com/topic/226850-change-part-of-the-data/ Share on other sites More sharing options...
Pikachu2000 Posted February 6, 2011 Share Posted February 6, 2011 This should work just fine, but as with anything that alters data, you should back up the table before you run it. UPDATE `table` SET `field` = REPLACE(`field`, 'http://openzelda.thegaminguniverse.com', 'http://openzelda.thegaminguniverse.org') Link to comment https://forums.phpfreaks.com/topic/226850-change-part-of-the-data/#findComment-1170530 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.