/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 vote129 views1 answer
Background image in laravel blade
PHP Laravel
1 vote116 views1 answer
Invalid datetime format laravel
PHP Laravel
1 vote109 views1 answer
How create page 419 in laravel
PHP Laravel
0 vote127 views1 answer
Laravel 5.7
PHP Laravel
0 vote123 views1 answer
Push to aws instance ssh without using laravel
PHP Laravel
0 vote112 views1 answer
Laravel check if api request
PHP Laravel
1 vote151 views1 answer
Laravel mongodb field delete (key delete) (column delete) drop
PHP Laravel
1 vote116 views1 answer
Date casting from datetime to d-m-Y laravel using cast
PHP Laravel
0 vote112 views3 answers
Laravel migration softdelete
PHP Laravel
7 votes103 views4 answers
How get role of user in laravel spatie
PHP Laravel

Share