/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 votes366 views1 answer
How send user to 404 page if not exist page in laravel
PHP Laravel
2 votes355 views2 answers
Laravel collection push
PHP Laravel
9 votes392 views4 answers
Composer require laravel/ui laravel 7
PHP Laravel
2 votes351 views1 answer
When image update laravel delete remove image
PHP Laravel
1 vote340 views3 answers
Check table exists in db laravel
PHP Laravel
10 votes335 views4 answers
Laravel table data types
PHP Laravel
4 votes345 views1 answer
TRANSACTON LARAVEL QUERY BUILDER
PHP Laravel
3 votes341 views3 answers
Laravel get a url using name
PHP Laravel
0 vote289 views1 answer
Laravel migrate patth
PHP Laravel
2 votes362 views1 answer
Laravel artisan create criteria
PHP Laravel

Share