Search and replace table field contents

Illustrate an image of a modern workspace with a computer monitor displaying a database management application.

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');

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top