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 '' Quote Link to comment 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. Quote Link to comment 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.. Quote Link to comment 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.