/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 vote153 views2 answers
Loop foreach laravel with number
PHP Laravel
15 votes152 views4 answers
Change existing migration laravel
PHP Laravel
1 vote153 views1 answer
Tackle discount in php laravel blade
PHP Laravel
3 votes166 views2 answers
Set image asset path in laravel
PHP Laravel
1 vote143 views1 answer
How create page 419 in laravel
PHP Laravel
0 vote167 views2 answers
Laravel collection search
PHP Laravel
1 vote150 views2 answers
Laravel log to console
PHP Laravel
0 vote148 views1 answer
Curl failed laravel centos
PHP Laravel
2 votes165 views2 answers
Get relationship data from soft delete laravel
PHP Laravel
3 votes217 views2 answers
Valdidate laravel if falid
PHP Laravel

Share