/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 vote195 views1 answer
Debugbar:clear in laravel
PHP Laravel
0 vote203 views1 answer
Get return value from another function laravel
PHP Laravel
0 vote207 views4 answers
Laravel pluck relationship
PHP Laravel
0 vote225 views1 answer
Laravel: Unknown: Failed opening required 'server.php' (include_path='php\PEAR
PHP Laravel
1 vote211 views1 answer
Run jobs laravel
PHP Laravel
0 vote199 views1 answer
Get record of last 24 hours in laravel
PHP Laravel
4 votes196 views2 answers
Numbric validate laravel
PHP Laravel
1 vote204 views6 answers
Laravel get url parameters in controller
PHP Laravel
12 votes187 views3 answers
Carbon in laravel documentation
PHP Laravel
0 vote212 views1 answer
Store image to s3 laravel
PHP Laravel

Share