MYSQL Find & Replace

To do a simple 'find and replace' in MySQL, use the following command :

update table set field = replace(field,'string_to_find','string_to_replace');
            

Find this article helpful?

Consider becoming a fan of our Facebook page! The link is in our fan box on the left!