/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

0 vote121 views1 answer
WithErrors laravel
PHP Laravel
1 vote135 views2 answers
If null blade laravel
PHP Laravel
0 vote132 views1 answer
Laravel schedule run
PHP Laravel
4 votes124 views2 answers
Laravel reduce
PHP Laravel
0 vote136 views1 answer
Polymorph laravel return order by
PHP Laravel
-1 vote130 views1 answer
Ziparchive laravel not found
PHP Laravel
4 votes136 views2 answers
Laravel attach
PHP Laravel
8 votes74 views2 answers
Laravel password hash online
PHP Laravel
0 vote127 views1 answer
Laravel value eloquent
PHP Laravel
2 votes123 views2 answers
Truncate table laravel eloquent
PHP Laravel

Share