/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

9 votes217 views3 answers
Laravel enum migration
PHP Laravel
13 votes216 views4 answers
Laravel make migration update table
PHP Laravel
0 vote270 views1 answer
Laravel reload relationship
PHP Laravel
0 vote222 views1 answer
Laravel datatable render html
PHP Laravel
1 vote243 views2 answers
Laravel throttle
PHP Laravel
23 votes235 views6 answers
Laravel 8 route
PHP Laravel
64 votes561 views6 answers
Delete cache laravel
PHP Laravel
9 votes225 views2 answers
How to write for loop in laravel blade
PHP Laravel
0 vote290 views1 answer
Redirect to intent url after login laravel
PHP Laravel
0 vote214 views2 answers
Laravel loop variable
PHP Laravel

Share