/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 vote269 views1 answer
Laravel carbon subtract minutes to current time
PHP Laravel
0 vote245 views1 answer
Laraverl add collect
PHP Laravel
6 votes270 views1 answer
Laravel scaffolding
PHP Laravel
-2 votes367 views1 answer
Errno: 150 foreign key constraint is incorrectly formed laravel 8
PHP Laravel
9 votes304 views5 answers
Laravel updateOrInsert
PHP Laravel
3 votes296 views1 answer
Back route laravel
PHP Laravel
39 votes309 views3 answers
Add new column to existing table laravel
PHP Laravel
2 votes264 views3 answers
Make model -mcr laravel
PHP Laravel
0 vote289 views5 answers
Laravel tricks and tips
PHP Laravel
7 votes287 views1 answer
Laravel auth user_id
PHP Laravel

Share