/PHP/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 vote207 views2 answers
Save big data with laravel
PHP Laravel
0 vote195 views1 answer
Laravelda cortollerga keladigan zaproslarni cheklash
PHP Laravel
0 vote162 views1 answer
How can we send attached file with notification in gmail in laravel 8
PHP
0 vote177 views2 answers
Laravel blade empty
PHP Laravel
0 vote159 views2 answers
How to connect to a mysql database using php
PHP
4 votes186 views4 answers
Laravel sum relationship column
PHP Laravel
0 vote153 views1 answer
Php round function Passing parameters with mode.
PHP
0 vote179 views1 answer
$request laravel undefined inside function query
PHP
5 votes192 views4 answers
Laravel response redirect
PHP Laravel
1 vote182 views2 answers
Use multiple database in laravel
PHP

Share