how can i update the value of json column key？

[lddlww]

example：

create table t1(id int , message json);
insert into t1 values(1,parse_json({a:1,b:1}));

i want to update message:b=2 when message:b=1

how can i do?

[BohuTANG]

Databend doesn't support update one item of the json.

[lddlww]

thanks for reply