/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

2 votes149 views2 answers
Laravel include config
PHP Laravel
0 vote144 views1 answer
Laravel php 8 ububtu
PHP Laravel
1 vote210 views1 answer
Boot method laravel
PHP Laravel
1 vote159 views1 answer
--prefer-dist what is use in laravel
PHP Laravel
8 votes144 views1 answer
Object not found in laravel xampp
PHP Laravel
0 vote147 views1 answer
Laravel return view with multiple variable
PHP Laravel
0 vote148 views1 answer
Display picture in pdf generated with laravel
PHP Laravel
0 vote186 views7 answers
Laravel eloquent tricks
PHP Laravel
2 votes299 views1 answer
How to set field type of date of birth in laravel
PHP Laravel
6 votes150 views2 answers
Laravel debugbar disable in production
PHP Laravel

Share