/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 vote322 views1 answer
Laravel app running in console
PHP Laravel
0 vote305 views1 answer
Laravel This package is not auto-updated. Please set up the GitHub Hook for Packagist so that it gets updated whenever you push!
PHP Laravel
3 votes300 views3 answers
Insert timestamps manually in laravel
PHP Laravel
2 votes321 views3 answers
How get file size in laravel
PHP Laravel
2 votes329 views1 answer
Laravel ever over https
PHP Laravel
4 votes348 views2 answers
Laravel blade errors all
PHP Laravel
3 votes310 views3 answers
Laravel carbon count days between dates
PHP Laravel
2 votes332 views1 answer
Multiple routes same controller laravel
PHP Laravel
1 vote325 views3 answers
Laravel api enable cors
PHP Laravel
7 votes320 views3 answers
Laravel search function
PHP Laravel

Share