Making a query on a table that has json field and postgresql database and laravel

Question

I have a table the has column that contains a json field and postgresql as database storage containing this example:

{"wants_newsletter": "true", "favorite_color": "red"}

If I query on laravel like:

$model = Model::where('column->favorite_color', 'red')->first();

I can get the row successfully and now can do like

$id = $model->id;

But when on the same column has this kind of json structure

{"wants_newsletter": ["true"], "favorite_color": ["red","blue"]}

If I query on laravel like:

$model = Model::where('column->favorite_color[0]', 'red')->first();

I get $model that is null, which mean I did not fetch a row.

How to do it in laravel?

DonUber · Accepted Answer · 2021-05-30 20:17:07Z

1

I think what you are looking for is:

->whereJsonContains('column->favorite_color', 'red')->first();

answered May 30, 2021 at 20:17

DonUber

828 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1