Laravel: How to query a json column for multiple conditions [duplicate]

Question

I have a simple json table containing an array of values:

[1,2,3,4,5,6,7,8,9]

I'm trying to query this table by multiple conditions:

This is what I currently have:

$data= Model::whereJsonContains('my_column', [2])->get();

This works for condition 1, now I can't seem to figure out how to include condition 2 as well.

Topically related: Count JSON Array in Query Builder and Eloquent: Getting sum of values (json property) based on weekday — mickmackusa
– mickmackusa ♦, Commented Dec 20, 2023 at 4:13

mighty_dev · Accepted Answer · 2023-12-20 05:40:37Z

1

Assuming your JSON array has unique values, you can use whereJsonLength to count the size of the JSON array like below:

$data = Model::whereJsonContains('my_column', 2)
              ->whereJsonLength('my_column', '>', 3)
              ->get();

answered Dec 20, 2023 at 5:40

mighty_dev

17.8k3 gold badges24 silver badges39 bronze badges

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

1 Answer 1