How to get put data into an Object in an array of objects

SQL++
1

Sample code

{
“Cities”: [
{
“citiId”: “3605”,
“aliases”: [],
“CityName”: “ABC”
},
{
“citiId”: “610”,
“aliases”: [],
“CityName”: “CCB”
},
{
“citiId”: “3434”,
“aliases”: [],
“citiName”: “XYz”
}
]
}

So how do you put data into aliases of object where citiName is ‘ABC’. I tried to get the whole object using N1ql, but unable to insert data into that aliases field.

Any help will be appriciated.

2

UPDATE cities SET aliases = XYZ WHERE citiName = ‘ABC’.