title: Update one field in blob in mysql
body: <p>I have one blob in a table which has following form :-</p>
  
  <pre><code>[{"name":"CREATED_BY_JOHN","description":"","alg":"None","srcPort":"","dstPort":"2345","disableTimeout":false}]
  </code></pre>
  
  <p>I want to upgrade the blobs "alg":"None" field to "alg":"null"</p>
  
  <p>How to do that in MySQL</p>
  
  <p>Can I do something like this :-</p>
  
  <pre><code>Update ApplicationEntity set protocolBlob='%"alg":"null"%' where protocolBlob like '%"alg":"None"%';
  </code></pre>