/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 vote377 views1 answer
Laravel creating_table_name
PHP Laravel
0 vote369 views2 answers
Pass guzzle client data to view laravel
PHP Laravel
7 votes411 views5 answers
Laravel model update table
PHP Laravel
1 vote375 views1 answer
Laravel add auto increment
PHP Laravel
4 votes426 views2 answers
Pass parameter to view laravel
PHP Laravel
31 votes339 views5 answers
How to make db seeder in laravel
PHP Laravel
0 vote357 views1 answer
Laravel compile assets
PHP Laravel
1 vote396 views1 answer
Laravel difference between fill and update
PHP Laravel
14 votes432 views4 answers
Laravel set timezone dynamically
PHP Laravel
1 vote300 views1 answer
Laravel data types
PHP Laravel

Share