/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 vote321 views2 answers
Foreach limit laravel
PHP Laravel
31 votes354 views6 answers
Make model with migration laravel
PHP Laravel
8 votes364 views3 answers
Validate time in laravel
PHP Laravel
6 votes310 views2 answers
Laravel check if request has value
PHP Laravel
13 votes300 views3 answers
Laravel string
PHP Laravel
0 vote360 views1 answer
How to select and deselect all items without use name in laravel
PHP Laravel
1 vote329 views2 answers
Laravel 8
PHP Laravel
0 vote314 views1 answer
Spatie laravel pdf image
PHP Laravel
6 votes327 views1 answer
Join 2 tables laravel
PHP Laravel
1 vote278 views1 answer
Laravel http request plain text
PHP Laravel

Share