/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 vote145 views1 answer
How to create table for every user in laravel
PHP Laravel
46 votes175 views5 answers
Add column migration laravel
PHP Laravel
0 vote139 views1 answer
Check if variable is set and not empty laravel
PHP Laravel
0 vote147 views1 answer
Logout from all the devices in the jwt api laravel
PHP Laravel
20 votes147 views6 answers
Laravel validation types
PHP Laravel
0 vote185 views1 answer
Laravel image ratio validation
PHP Laravel
0 vote138 views1 answer
Exists:categories,id except a value laravel
PHP Laravel
0 vote156 views1 answer
Implement class in autoloader athow to implment data table in laravel project
PHP Laravel
1 vote160 views1 answer
How validate data if is exist must not be empty in laravel
PHP Laravel
2 votes151 views1 answer
Laravel get subdomain
PHP Laravel

Share