/PHP/Laravel/Laravel where json array column

Laravel where json array column

Laravel where json array column

->whereJsonContains('user_id', 3)

0

Source: laracasts.com

Laravel where json array column

whereRaw("JSON_CONTAINS(user_id, '[3]' )")->get();

0

Source: laracasts.com

Laravel where json array column

$listOfUser = [1, 3, 5, 6, 8, 9];

$users = DB::table('users')
                    ->whereIn('user_id', $listOfUser)
                    ->get();

0

Source: laracasts.com

Similar codes

1 vote242 views2 answers
Laravel api too many requests
PHP Laravel
48 votes231 views2 answers
Laravel check my laravel version
PHP Laravel
1 vote180 views2 answers
Laravel return response view
PHP Laravel
9 votes180 views4 answers
Laravel time format
PHP Laravel
6 votes178 views3 answers
Laravel 8 with jetstream
PHP Laravel
1 vote276 views1 answer
I cannot login to my CPanel hosted Laravel Application, my SSL has expired
PHP Laravel
0 vote186 views1 answer
Laravel eloquent hasmany select
PHP Laravel
0 vote204 views1 answer
Doiffernce between text and string in laravel migration
PHP Laravel
1 vote175 views1 answer
Date format in laravel month name day name
PHP Laravel
0 vote196 views1 answer
Laravel collection average
PHP Laravel

Share