/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 vote202 views1 answer
Laravel override eloquent all function
PHP Laravel
0 vote218 views1 answer
Iqbal Laravel save record in two table in one line
PHP Laravel
0 vote215 views1 answer
Laravel get relation camelcase api
PHP Laravel
3 votes213 views1 answer
Install all necessary php packages for laravel
PHP Laravel
9 votes223 views5 answers
Laravel updateOrInsert
PHP Laravel
0 vote211 views1 answer
Laravel update all relations
PHP Laravel
0 vote216 views2 answers
Laravel download file from public folder
PHP Laravel
1 vote192 views1 answer
Laravel stoage link brakes when pushed on production
PHP Laravel
5 votes221 views4 answers
Create database from migration laravel for all
PHP Laravel
0 vote169 views1 answer
Laraverl add collect
PHP Laravel

Share