UPDATE column with VARCHAR(2) 4000 byte value
<p>I want to update a table with complex entries in a column and just a clause in the column without effecting other values. </p>

<p>Want to update <code>#Rule number=0#</code> to <code>#Rule number=1#</code> but without affecting other values in the column. Is this possible?
<a href="https://i.stack.imgur.com/wotM5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wotM5.png" alt="enter image description here"></a></p>