/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 vote372 views1 answer
Laravel password require one letter and one number
PHP Laravel
0 vote389 views1 answer
Function is not defined laravel
PHP Laravel
2 votes373 views2 answers
Laravel foreach first
PHP Laravel
2 votes399 views2 answers
Laravel get random number of data from database
PHP Laravel
0 vote392 views1 answer
Laravel file custom name
PHP Laravel
43 votes353 views6 answers
Laravel cache
PHP Laravel
5 votes340 views2 answers
Laravel vue
PHP Laravel
1 vote382 views2 answers
How to delete a file in laravel
PHP Laravel
26 votes412 views6 answers
Laravel make model with migration and controller
PHP Laravel
0 vote380 views3 answers
Laravel get all records order by
PHP Laravel

Share