/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 vote251 views1 answer
Send emails with runtime configurations in laravelk
PHP Laravel
0 vote228 views1 answer
Laravel blank page
PHP Laravel
24 votes281 views6 answers
Laravel create model
PHP Laravel
0 vote247 views1 answer
How to validate email or phone number single parameter request in laravel
PHP Laravel
4 votes229 views5 answers
Laravel db inserr
PHP Laravel
1 vote244 views1 answer
Laravel test cases
PHP Laravel
0 vote272 views2 answers
Laravel notification database
PHP Laravel
1 vote229 views1 answer
Protected gaurded in laravel
PHP Laravel
2 votes227 views3 answers
Php laravel dump
PHP Laravel
0 vote226 views1 answer
Laravel CORS config `allowed_origins` should be an array
PHP Laravel

Share