laravel table json column type code example

Example 1: laravel where json array column

->whereJsonContains('user_id', 3)

Example 2: laravel where json array column

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

$users = DB::table('users')
                    ->whereIn('user_id', $listOfUser)
                    ->get();