mattc_uk Posted March 11, 2011 Share Posted March 11, 2011 I need to work out what SQL command I use to update (replace) only part of a field. Is this possible? Example: I have a load of records like this in a table called 'contacts' ID: 1 First Name: Joe Last Name: Bloggs Email: something@something.com Website: <a href="www.website.com">Link</a> How do I change every record in my database so the end part of Website records say ... >Website</a> instead of >Link</a> ? Im guessing the command would start with UPDATE contacts SET website ='>website</a>' WHERE website {some command here} '>link</a>' ? Cheers Matt Quote Link to comment https://forums.phpfreaks.com/topic/230316-update-command-to-alter-part-of-a-field-entry/ Share on other sites More sharing options...
mattc_uk Posted March 11, 2011 Author Share Posted March 11, 2011 No worries, I've found it UPDATE contacts SET website=REPLACE(website, '>link</a>', '>website</a>') :-) Quote Link to comment https://forums.phpfreaks.com/topic/230316-update-command-to-alter-part-of-a-field-entry/#findComment-1186118 Share on other sites More sharing options...
fenway Posted March 11, 2011 Share Posted March 11, 2011 An UPDATE without a WHERE clause -- very scary. Quote Link to comment https://forums.phpfreaks.com/topic/230316-update-command-to-alter-part-of-a-field-entry/#findComment-1186296 Share on other sites More sharing options...
mattc_uk Posted March 12, 2011 Author Share Posted March 12, 2011 Thats why I backed up the database first ;-) no need tho it worked a treat :-) Quote Link to comment https://forums.phpfreaks.com/topic/230316-update-command-to-alter-part-of-a-field-entry/#findComment-1186740 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.