/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 vote138 views1 answer
Laravel get week dates
PHP Laravel
0 vote129 views2 answers
How to disable laravel cors
PHP Laravel
7 votes148 views3 answers
How to remove public from url in laravel 8
PHP Laravel
0 vote157 views1 answer
Laravel collection intersectKey
PHP Laravel
0 vote137 views2 answers
Laravel limit foreach
PHP Laravel
1 vote135 views1 answer
Laravel optional route parameter in middle of url
PHP Laravel
0 vote131 views1 answer
A facade root has not been set laravel 7
PHP Laravel
1 vote138 views1 answer
Image dimension when uploading in laravel validation
PHP Laravel
0 vote129 views1 answer
Laravel map the output of the api
PHP Laravel
1 vote119 views1 answer
Password validation rules laravel
PHP Laravel

Share