karldesign Posted August 3, 2007 Share Posted August 3, 2007 Is it possible to edit text within a text field in phpmyadmin on mass scale? We have over 1000 records and want to delete a unique/specific phrase from within the text field: ie: we have 'ITEM TO BE REPLACED' with '' Link to comment https://forums.phpfreaks.com/topic/63164-phpmyadmin-mass-content-delete/ Share on other sites More sharing options...
Illusion Posted August 3, 2007 Share Posted August 3, 2007 While retrieving the data we can use REPLACE() to get the desired result and I don't really we can update using that. Link to comment https://forums.phpfreaks.com/topic/63164-phpmyadmin-mass-content-delete/#findComment-314824 Share on other sites More sharing options...
jaymc Posted August 3, 2007 Share Posted August 3, 2007 Is the text exactly the same in your 1000 rows If not your would need to throw each row out to PHP, use replace then update the row.. Link to comment https://forums.phpfreaks.com/topic/63164-phpmyadmin-mass-content-delete/#findComment-315163 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.