Wednesday, September 16, 2009

Find and Replace data in MySQL using phpmyadmin

in phpmyadmin run this SQL query

update table_name set field_name = replace(field_name, ‘Old Data’, ‘New Data’)


table_name is the name of table in database

field_name is the name of the column in your table