/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

9 votes201 views5 answers
Laravel exist
PHP Laravel
0 vote229 views1 answer
Send image in request body laravel 6
PHP Laravel
11 votes247 views6 answers
Laravel route
PHP Laravel
19 votes205 views6 answers
Laravel 8 make model with migration and controller
PHP Laravel
1 vote218 views1 answer
Check if delete query was successful laravel
PHP Laravel
0 vote232 views1 answer
Sort by number of views descending laravel
PHP Laravel
13 votes189 views4 answers
Laravel hash
PHP Laravel
0 vote199 views1 answer
Laravel get only validated data
PHP Laravel
0 vote214 views1 answer
Laravel8 can't read env
PHP Laravel
0 vote240 views1 answer
Laravel blade php variable concatenate javascript variable
PHP Laravel

Share