Hosted sites: 107,622 | Average server uptime last month: 99.9%

phpMyAdmin - Search and Replace

Sometimes you have messed up characters in your database - wrong character encodings - or you want to strip out some text in a certain table's field.

In phpMyAdmin, open up the SQL dialog and use the following code (change tablename and tablefield to your name and field values):

UPDATE tablename SET tablefield = replace(tablefield, "findstring", "replacestring");

 
findus-fb

Follow Us On Twitter

We accept:

Martfox Hosting

Martfox offers the highest quality web hosting services at the lowest possible prices. We make web hosting simple, so that you can relax and focus on your core business.

Martfox Servers

All of our servers are supplied Supermicro and feature some of the best server-grade hardware. All servers feature 4GB+ of memory and RAID protected storage.

CS-Cart Community

Good news for owners of the CS-Cart trial license! From now on, after registration on the CS-Cart forum you will be able not only to read messages but also to post your own ones.

LiveZilla Live Help