Answers for "laravel search in json column"

PHP
0

laravel where json array column

->whereJsonContains('user_id', 3)
Posted by: Guest on October-28-2020
0

Laravel JSON Where Query

$users = DB::table('users')
                ->where('options->language', 'en')
                ->get();

$users = DB::table('users')
                ->where('preferences->dining->meal', 'salad')
                ->get();
Posted by: Guest on July-28-2021
0

laravel where json array column

$listOfUser = [1, 3, 5, 6, 8, 9];

$users = DB::table('users')
                    ->whereIn('user_id', $listOfUser)
                    ->get();
Posted by: Guest on October-28-2020

Browse Popular Code Answers by Language