There are a couple of ways you can replace entries in your database - from within phpMyAdmin, using an SSH command, or using a text editor such as NotePadQQ (Linux) and NotePad++(Windows). In this article, we will explore the way you can do that from phpMyAdmin and we will cover the rest in separate guides.
Please take a look at our tutorial on How to search your database using phpMyAdmin. After reaching Step 11, you will also notice two buttons that correspond to each table containing a match - the "Browse" and "Delete" buttons. To replace the old value, do the following:
- Please press the "Browse" button.
- Your database table containing these specific values will be shown at the bottom of the page.
- Double-click inside the field containing the old string. This action will turn the text field into a content box, allowing you to change the value.
- After the change is made, press the "ENTER" button on your keyboard.
This technique comes in handy when there are only a few matches to replace.