Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
I have to make a query that does the following: I have a json field casted as array, I want to count the number of values inside this array and compare it with an input. Let's say user inputs 3 and in the db we have {'item1','item2','item3'}, it should return true
The array casting is in the Model (PHP-land) only right now; but you can determine a count within a MySQL query using JSON_LENGTH function. https://dev.mysql.com/doc/refman/5.7/en/json-attribute-functions.html#function_json-length
Aside, are those the correct brackets - is that an actual value in the database?
@tykus the actual value is like this
["google","facebook","instagram"]
@tykus Tried like this but always returns null
$query->selectRaw("JSON_LENGTH('past_deals') as x")
@Kris01 okay, so it is [ and ], not { and }
I have absolutely nothing to work with as far as your Model/column name etc, so broadly the query can look like:
$count = Model::selectRaw("JSON_LENGTH(column_name, '$') as count")->value('count');
Please or to participate in this conversation.