表中有一个blob，其形式如下：-

[{"name":"CREATED_BY_JOHN","description":"","alg":"None","srcPort":"","dstPort":"2345","disableTimeout":false}]

我想将blobs“alg”：“none”字段升级为“alg”：“null”
在mysql中如何做到这一点
我可以这样做吗：-

Update ApplicationEntity set protocolBlob='%"alg":"null"%' where protocolBlob like '%"alg":"None"%';