Wednesday, September 16, 2009

Find and Replace in MySQL

in phpmyadmin run this SQL query

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