/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 vote248 views1 answer
Call variable from inside a collection laravel
PHP Laravel
1 vote243 views1 answer
Laravel foreach else
PHP Laravel
5 votes223 views1 answer
Laravel model method like foreach parts of
PHP Laravel
1 vote228 views6 answers
Laravel get url parameters in controller
PHP Laravel
50 votes263 views6 answers
Laravel database seeder
PHP Laravel
6 votes234 views4 answers
Unique check with multiple columns laravel validation
PHP Laravel
6 votes231 views1 answer
Join 2 tables laravel
PHP Laravel
0 vote240 views4 answers
Installing bootstrap on laravel8
PHP Laravel
0 vote250 views1 answer
Laravel count the types of users
PHP Laravel
4 votes237 views1 answer
Create view from route laravel
PHP Laravel

Share