How to Find and Replace text inside a data field in SQL (string manipulation)

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.

Tagged with: ,
Posted in uncategorized misfits
2 comments on “How to Find and Replace text inside a data field in SQL (string manipulation)
  1. Hello there, just became aware of your blog through Google, and found that it is truly informative. I am going to watch out for brussels. Ill be grateful if you continue this in future. Plenty of people will be benefited from your writing. Cheers!

  2. Shay Zamir says:

    F*ckin’ tremendous things here. I’m very satisfied to look your post. Thanks so much and i am looking ahead to touch you. Will you kindly drop me a e-mail?