/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

1 vote366 views1 answer
Laravel add auto increment
PHP Laravel
0 vote356 views1 answer
Update onlu one column laravel
PHP Laravel
0 vote387 views1 answer
How to take last entry in database in laravel Method Two
PHP Laravel
1 vote376 views1 answer
Config smp gamil laravel
PHP Laravel
0 vote371 views1 answer
Store as real file name laravel uplaod
PHP Laravel
8 votes328 views6 answers
Relationship in laravel
PHP Laravel
1 vote409 views1 answer
Default index page for laravel in cpanel
PHP Laravel
12 votes422 views2 answers
Creating a Basic Route in Laravel 8
PHP Laravel
6 votes378 views1 answer
Laravel eloquent whereDateBetween
PHP Laravel
1 vote348 views1 answer
Laravel model find one
PHP Laravel

Share