/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 vote157 views1 answer
How to pass parameter to middleware from route in laravel
PHP Laravel
0 vote218 views1 answer
Href in laravel view
PHP Laravel
0 vote164 views1 answer
Laravel post index method
PHP Laravel
5 votes178 views5 answers
Laravel get all request parameters
PHP Laravel
8 votes203 views1 answer
Laravel sotrage linkl
PHP Laravel
2 votes206 views1 answer
Laravel sluggable
PHP Laravel
0 vote222 views1 answer
How to retrieve data from database using select option in laravel
PHP Laravel
0 vote201 views1 answer
Stdclass not found laravel
PHP Laravel
12 votes195 views2 answers
Tomorrow carbon laravel
PHP Laravel
1 vote139 views1 answer
Laravel database procedures
PHP Laravel

Share