/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 vote216 views1 answer
Disable laravel cors
PHP Laravel
0 vote347 views1 answer
Laravel timestamps on pivot table
PHP Laravel
0 vote241 views1 answer
Check null if string laravel
PHP Laravel
19 votes204 views5 answers
Php artisan auth in laravel 8
PHP Laravel
53 votes583 views6 answers
Laravel join
PHP Laravel
0 vote234 views1 answer
Laravelda cortollerga keladigan zaproslarni cheklash
PHP Laravel
0 vote170 views1 answer
Laravel mix build as umd
PHP Laravel
0 vote228 views1 answer
How to display all posts assocatied to user in laravel
PHP Laravel
0 vote232 views1 answer
Create a exporter in laravel command
PHP Laravel
-1 vote219 views4 answers
How to include file in laravel blade
PHP Laravel

Share