update [table_name] set [field_name] =
replace([field_name],'[string_to_find]','[string_to_replace]');

Why is this useful for WordPress?

Well sometimes you want to update a code snippet or something pasted across multiple posts.