/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 vote187 views1 answer
Laravel makeHidden
PHP Laravel
53 votes265 views6 answers
Laravel where in
PHP Laravel
0 vote207 views1 answer
Laravel Http client retry request if fail
PHP Laravel
0 vote208 views1 answer
How run all seeder at once in laravel
PHP Laravel
9 votes206 views3 answers
Show all validation errors in laravel's blade view
PHP Laravel
7 votes204 views5 answers
Laravel foreach loop index
PHP Laravel
0 vote193 views1 answer
Laravel schedule run
PHP Laravel
0 vote205 views3 answers
Laravel 'Choice question must have at least 1 choice available.'
PHP Laravel
0 vote215 views1 answer
Remove controller cache laravel
PHP Laravel
0 vote187 views1 answer
Laravel truncate string laravel 8
PHP Laravel

Share