HostArmada Web Hosting Knowledge Base

Knowledge is power! Use that power and achieve total and unconditional control over the Web Hosting Services!

How to replace database entries using phpMyAdmin?

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.

 

Browse MySQL Database Query Search Results

 

  • 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.

 

Replace MySQL Database Entry in phpMyAdmin

 

  • 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.

Was this article useful and on point?

Find out more about HostArmada entire range of optimized Web Hosting Services and take action today on improving your website Loading Speed, Security, and overall Stability!