/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 vote356 views4 answers
Image Upload in Laravel
PHP Laravel
3 votes279 views1 answer
Sum multiple fields separately in laravel
PHP Laravel
1 vote314 views2 answers
Laravel view data
PHP Laravel
2 votes356 views6 answers
Laravel 8 ui auth
PHP Laravel
2 votes308 views3 answers
How to share a helper globally laravel
PHP Laravel
0 vote307 views1 answer
Laravel permit only some inputs
PHP Laravel
1 vote310 views1 answer
Laravel test cases
PHP Laravel
7 votes309 views3 answers
Call table name in model laravel
PHP Laravel
1 vote338 views1 answer
[InvalidArgumentException] Could not find package laravel/laravel with version 7.0 in a version installable using your PHP version, PHP extensions and Composer version.
PHP Laravel
0 vote333 views1 answer
Laravel collection intersectKey
PHP Laravel

Share