SupabaseS
Supabase•4y ago
w3mw

Update json file from define as array?

Hello, I have a table, where I have a column call teams with json[] (defined as array).

I know that I can insert json to it. But is it possible to update an object inside that array in that json file?

[
  {
    "id": 1,
    "name": "Arsenal",
    "url": "https://icons.iconarchive.com/icons/giannis-zographos/english-football-club/256/Arsenal-FC-icon.png"
  },
  {
    "id": 2,
    "name": "Chelsea",
    "url": "https://icons.iconarchive.com/icons/giannis-zographos/english-football-club/256/Chelsea-FC-icon.png"
  },]


So If I would like to update the seconds object, id 2 to name "United" instead of Chelsea, is that possible?
Was this page helpful?