I have records with blob fields, and in them I am trying to replace strings, say: test1 with test2. However, I am afraid I will be overwriting a word like test1111 to look like test11112 with my query:
set post_text = replace(post_text, 'test1', 'test2')
where post_text like '%test1%'
Is there safer way to do this without overwriting parts of the string found?
Thanks for you time in assisting me.