/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

1 vote303 views1 answer
How to return data in json format in laravel
PHP Laravel
6 votes331 views1 answer
Laravel add attribute migration column
PHP Laravel
1 vote310 views1 answer
Use app name in laravel blade
PHP Laravel
2 votes273 views1 answer
Laravel guest blade
PHP Laravel
1 vote326 views1 answer
Static function model laravel
PHP Laravel
1 vote329 views1 answer
Laravel gates
PHP Laravel
5 votes304 views5 answers
Laravel composer update
PHP Laravel
1 vote264 views1 answer
Persian error laravel
PHP Laravel
1 vote270 views2 answers
Laravel blade dump
PHP Laravel
10 votes281 views2 answers
Try and catch laravel
PHP Laravel

Share