/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 votes276 views3 answers
How to get the size of an uploaded file in laravel
PHP Laravel
0 vote309 views1 answer
How run job laravel in cpanel host
PHP Laravel
0 vote262 views1 answer
Scribe laravel
PHP Laravel
1 vote251 views2 answers
Laravel cronjob
PHP Laravel
0 vote287 views1 answer
Laravel where doesn't have
PHP Laravel
0 vote282 views1 answer
Macos how host laravel website on localhost and intranet wifi
PHP Laravel
0 vote280 views1 answer
Add variables to line in laravel notification
PHP Laravel
1 vote273 views3 answers
Queue jobs in laravel
PHP Laravel
0 vote265 views1 answer
How to separate admin and user login in laravel
PHP Laravel
0 vote254 views1 answer
Creating default object from empty value laravel
PHP Laravel

Share