Laravel eloquent query to get records with array with specified length

Question

It seems like this should be pretty simple to find the answer to but apparently not for me. I need to query a count of records where the field called bullets contains an array with a length of 5. Here is what I currently have but it's checking for character length of the field itself(I believe), not of an array. Can anyone help me out please?

$vcount = Variation::where('user_id', user_id)->whereRaw('LENGTH(bullets) = 5')->count();

Try using the JSON_LENGTH sql function to get the number of elements in the array. — pmcpimentel
– pmcpimentel, Commented Jun 23, 2022 at 23:15
@pmcpimentel Thanks for the suggestion but this didn't work for me (Or maybe my syntax was wrong). I ended up finding whereJsonLength() in this thread stackoverflow.com/questions/50820839/… Will post the answer below — Christine Treacy
– Christine Treacy, Commented Jun 24, 2022 at 14:00

Christine Treacy · Accepted Answer · 2022-06-24 14:02:16Z

1

thanks to this thread Laravel 5.6. JSONb column. Count array

I found whereJsonLength() that worked for my use case:

$vcount = Variation::where('user_id', user_id)->whereJsonLength('bullets', '=', 5)->count();

answered Jun 24, 2022 at 14:02

Christine Treacy

2223 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

Laravel eloquent query to get records with array with specified length

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related