/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 vote335 views1 answer
Laravel faker title
PHP Laravel
0 vote353 views1 answer
Laravel return view in web.php
PHP Laravel
0 vote330 views1 answer
Parameter to laravel seeder
PHP Laravel
0 vote344 views1 answer
Laravel raw query join many to many
PHP Laravel
2 votes352 views1 answer
Laravel request validation rules for create and update
PHP Laravel
0 vote352 views1 answer
Laravel change error page to open in vscode
PHP Laravel
15 votes336 views6 answers
Confirm password validation in laravel
PHP Laravel
2 votes326 views1 answer
Laravel app get locale
PHP Laravel
0 vote352 views1 answer
Laravel permission spatie cache clear
PHP Laravel
1 vote351 views1 answer
Laravel 8 bootstrap pagination fix
PHP Laravel

Share