whereJsonContains usage | Laravel | Page 1

leaden path Aug 5, 2024, 4:38 PM

#

I have a user_data column on the options table with this record [{‘x’:’111’},{‘y’:’5555’}], how can I retrieve options where y = 5555 with the whereJsonContains

tropic summit Aug 5, 2024, 6:35 PM

#

With whereJsonContains('user_data->y', '5555') 😉

leaden path Aug 5, 2024, 7:40 PM

#

The syntax you give is not working. It output an empty array

tropic summit Aug 5, 2024, 7:56 PM

#

It's from doc - https://laravel.com/docs/11.x/queries#json-where-clauses
and simple where('user_data->y', '5555') ?

Laravel - The PHP Framework For Web Artisans

Laravel is a PHP web application framework with expressive, elegant syntax. We’ve already laid the foundation — freeing you to create without sweating the small things.

#

I assume that this column has type json, right?

leaden path Aug 5, 2024, 8:06 PM

#

Yes I try it before posting the question

#

Note that in the json you get x as a key in one object and y as a key on the other object

#

Your syntax work in the case where you have something like this [{‘x’:’3333´}, {‘x’:’4444’}]

tropic summit Aug 5, 2024, 8:28 PM

#

Ok, i tested it and it seems that for json array content it should be like this whereJsonContains('user_data', ['y' => '5555'])

#whereJsonContains usage