/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

6 votes156 views3 answers
How to get parameter from url in laravel blade
PHP Laravel
1 vote173 views3 answers
Convert date to timestamp in laravel builder
PHP Laravel
0 vote175 views2 answers
Laravel get path to storage folder
PHP Laravel
0 vote180 views1 answer
Laravel save or post
PHP Laravel
0 vote177 views2 answers
Laravel get url without domain in blade
PHP Laravel
0 vote172 views1 answer
How to loop array in laravel
PHP Laravel
1 vote169 views1 answer
Class 'illuminate support facades input' not found laravel 7
PHP Laravel
0 vote168 views1 answer
Laravel Password & Password_Confirmation Validation
PHP Laravel
0 vote179 views1 answer
Foreach empty laravel
PHP Laravel
1 vote200 views1 answer
Start server in laravel
PHP Laravel

Share