15 Dec 08 MySQL search and replace

Posted by Hans-Henry Jakobsen

This is a simple SQL query to perform search and replace in a MySQL table

update tablename set fieldname = replace(fieldname,'search_for_this','replace_with_this');

Tags: MySQL