/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

14 votes358 views5 answers
Laravel model tablename
PHP Laravel
2 votes401 views1 answer
Foreign key constraint is incorrectly formed laravel
PHP Laravel
1 vote347 views1 answer
Laravel blade skip entry
PHP Laravel
7 votes323 views3 answers
Laravel get latest
PHP Laravel
0 vote342 views1 answer
Laravel mcq questions
PHP Laravel
0 vote345 views1 answer
Die laravel
PHP Laravel
-1 vote341 views1 answer
Toast in laravel
PHP Laravel
1 vote333 views2 answers
Force https redirection laravel
PHP Laravel
12 votes326 views2 answers
Laravel update from query
PHP Laravel
0 vote403 views1 answer
Laravel nova create user
PHP Laravel

Share