/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 vote154 views1 answer
How to add a clock in laravel
PHP Laravel
44 votes215 views6 answers
How to create controller in laravel
PHP Laravel
-1 vote159 views4 answers
Laravel create command tutorial
PHP Laravel
0 vote194 views1 answer
Diffforhumans laravel
PHP Laravel
0 vote155 views1 answer
How to validate multi image upload in laravel
PHP Laravel
0 vote157 views2 answers
Laravel collection remove duplicates
PHP Laravel
1 vote317 views1 answer
How to stop laravel server
PHP Laravel
1 vote209 views4 answers
Laravel scheduler run
PHP Laravel
7 votes184 views4 answers
With message in laravel
PHP Laravel
0 vote178 views1 answer
Laravel collection intersectKey
PHP Laravel

Share