/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 vote182 views1 answer
How to get meta information from pagination in laravel controller
PHP Laravel
0 vote294 views1 answer
Show sender name laravel
PHP Laravel
0 vote183 views2 answers
String to array in laravel
PHP Laravel
0 vote177 views1 answer
->store() laravel change name
PHP Laravel
1 vote154 views3 answers
Display pdf file in laravel
PHP Laravel
-1 vote168 views1 answer
Clear Caching of Queries Laravel Specific Model Cache
PHP Laravel
1 vote185 views2 answers
Use multiple database in laravel
PHP Laravel
1 vote175 views2 answers
Laravel make directory
PHP Laravel
6 votes201 views3 answers
Laravel ide helper
PHP Laravel
0 vote179 views1 answer
Update onlu one column laravel
PHP Laravel

Share