/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

4 votes191 views1 answer
Use str laravel
PHP Laravel
30 votes203 views6 answers
Laravel insert
PHP Laravel
15 votes210 views1 answer
Laravel composer install ignore
PHP Laravel
1 vote150 views2 answers
Laravel check if id in collection
PHP Laravel
1 vote212 views1 answer
How to check exist in array in rule validation laravel
PHP Laravel
0 vote201 views2 answers
Laravel get path to storage folder
PHP Laravel
0 vote194 views1 answer
Dump die laravel
PHP Laravel
0 vote258 views2 answers
Laravel has one through relationship
PHP Laravel
-1 vote187 views4 answers
Laravel create command tutorial
PHP Laravel
0 vote206 views1 answer
Add selected to dropdpown item laravel
PHP Laravel

Share