[CMS] Search and replace data using PHPMYADMIN

Use the following command to search and replace specific data in a specific column in a table.

update my_specific_table set my_specific_table_column = replace(my_specific_table_column, 'XXXXX' , 'AAAAA')

Explanation

It is important to run this SQL command in PHPMYADMIN as a SQL QUERY. You will be able to simulate this query before running the actual update.

my_specific_table = Table where the search/replace will be performed
my_specific_table_column = Column within the specific table, where the search/replace will be performed.

XXXXX = is the string to search for
AAAAA = is the new string which will replace the old string

About us

E:

We are a web development agency located in Cape Town, South Africa. We design great looking websites. We are CSS enthusiasts. We specialise in Content management systems. We are a professional Team with over 30 years of experience. Learn more.

facebook  linkedin  twitter  linkedin

Office South Africa

E: za [AT] raramuridesign [DOT] com
T:
 +27 21 913 7872
Mon - Fri 09h00-16h30 (ZA)