The query below will replace all occurences of “Bob Loblaw Law Blog” found in the field “BlogName” field of the Blogs table. All instances of the string are being replaced, and the search is case sensitive. The function is also multi-byte safe.

1. UPDATE Blogs SET BlogName = REPLACE(Blogs,'Bob Loblaw Law Blog','BLLB');