MySql find & replace

Having recently moved the blog from to I discovered that the images within the posts were now broken, I could manually go through each post and reattach the images but performing a find and replace on the MySql database would be a much quicker way of getting things back on track.

update [table_name] set [field_name] = replace([field_name],