```
  id        Weather

   1    {{KS,'S'},{MO,'S'},{CA,'S'}}

```

I am trying to update 'S' to 'W' for all KS,MO,CA.

I am executing below query and it is throwing me an error

```
 UPDATE table
 SET Weather[][2] ='W' where id=1;

```

expected output 

```
  id        Weather

   1    {{KS,'W'},{MO,'W'},{CA,'W'}}

```