Level 24
Is length a JSON column?
Nov 16, 2018
3
Level 13
select from array field in database
I have a database table with three fields
id (integer) say value=> 1
color (string) say value => 'red'
length (array) [1 , 8]
how can I select where color = 'red' and the given length in length between 1 and 8?
ps iam using laravel eloquent...
Level 13
@STAUDENMEIR - yes
Level 24
In Laravel 5.6+, you can use whereJsonContains(): https://laravel.com/docs/queries#json-where-clauses
1 like
Please or to participate in this conversation.