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. Quote 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') Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.