/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 vote127 views1 answer
Laravel delete file after download
PHP Laravel
0 vote118 views1 answer
Laravel npm run dev mix error FIX
PHP Laravel
5 votes156 views2 answers
Laravel mail send
PHP Laravel
4 votes136 views3 answers
Laravel migration index
PHP Laravel
1 vote127 views1 answer
How to define variable as object in blade laravel
PHP Laravel
1 vote117 views1 answer
Laravel create on model
PHP Laravel
0 vote129 views1 answer
Laravel create pivot migration
PHP Laravel
1 vote125 views3 answers
Laravel get input from request
PHP Laravel
44 votes129 views4 answers
Laravel random string
PHP Laravel
7 votes119 views4 answers
Laravel route namespace and prefix
PHP Laravel

Share