/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

9 votes216 views5 answers
Laravel updateOrInsert
PHP Laravel
1 vote201 views1 answer
Tackle discount in php laravel blade
PHP Laravel
0 vote230 views1 answer
Laravel parse markdown
PHP Laravel
0 vote230 views6 answers
Use varable on all site pages laravel
PHP Laravel
0 vote259 views1 answer
Return single row from eloquent all collection laravel
PHP Laravel
1 vote205 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_api.sessions' doesn't exist (SQL: select * from `sessions` where `id` = sXWuwluhxC2HlCzzq7jDyPGJFriLGdxQj8bPtcgC limit 1)
PHP Laravel
1 vote210 views2 answers
Page expire in laravel
PHP Laravel
10 votes218 views6 answers
Format time laravel
PHP Laravel
19 votes203 views6 answers
Laravel Route Group
PHP Laravel
0 vote262 views1 answer
Laravel simplexmlelement not found
PHP Laravel

Share