how to update jsonb column using laravel query

I want to update the available to false where toy->id=27. Can any give me the laravel eloquent query for this? Thanks.

{
   "color":"red",
   "toy":{
      "id":27,
      "name":"Truck",
      "price":12,
      "available":true
   },
   "quantity":"12"
}

Level 102

->update(['columnname->toy->available' => false]);

Level 1

Thanks for your quick response.

I am using Laravel 5.8.38, and in your query where do, we define where clause? I want something like below

Update available where toy->id=27.

Level 102

@belt consider using a second table instead then

Please or to participate in this conversation.