How to replace any word in phpmyadmin?


Here is simple way to replace any word in phpmyadmin at mysql database.

 

1. Login to Your Cpanel or other Panel

 

2. Click on “PHPMyadmin”

 

3. Now, Select a “Database” from left slide menu.

 

4. Then, click on “SQL”

 

5. Now, Copy and Paste following codes in The box and Click on “GO” button.

 update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, 'Text to find', 'text to replace with');

 

 

6. Result

https://betterstudio.com/wp-content/uploads/2019/07/rows-affected.jpg

 

Done…

 



Find More related How to replace any word in phpmyadmin?


Have any Question or Comment?

Leave a Reply

Your email address will not be published. Required fields are marked *