/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

29 votes181 views3 answers
Seed date laravel
PHP Laravel
-1 vote123 views3 answers
Grouping route in laravel
PHP Laravel
0 vote122 views1 answer
Magento 2 laravel valet 502 bad gateway
PHP Laravel
0 vote141 views2 answers
Laravel eloquent without relation
PHP Laravel
2 votes135 views1 answer
Go back URL in Laravel
PHP Laravel
1 vote134 views3 answers
Import faker in laravel
PHP Laravel
0 vote136 views1 answer
Laravel adding new items to config run time
PHP Laravel
22 votes131 views4 answers
Laravel orWhere
PHP Laravel
1 vote141 views2 answers
Laravel SPA cors
PHP Laravel
5 votes134 views6 answers
Sync laravel
PHP Laravel

Share