/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

4 votes154 views2 answers
On update current timestamp laravel migration
PHP Laravel
8 votes139 views1 answer
Storage image not showing in laravel
PHP Laravel
1 vote159 views2 answers
Page expire in laravel
PHP Laravel
0 vote154 views1 answer
Laravel enable mysql logging
PHP Laravel
0 vote139 views2 answers
Laravel 8 query builder, Left Join / Right Join Clause
PHP Laravel
0 vote146 views1 answer
Scribe laravel
PHP Laravel
30 votes147 views6 answers
Laravel auth
PHP Laravel
0 vote156 views2 answers
Check method in laravel
PHP Laravel
0 vote159 views1 answer
Token delete laravel
PHP Laravel
48 votes183 views2 answers
Laravel check my laravel version
PHP Laravel

Share