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: [email protected] 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 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>') :-) 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. 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 :-) 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
Archived
This topic is now archived and is closed to further replies.