laravel where json array code example
Example 1: laravel where json array column
->whereJsonContains('user_id', 3)
Example 2: laravel where json array column
whereRaw("JSON_CONTAINS(user_id, '[3]' )")->get();
Example 3: laravel where json array column
$listOfUser = [1, 3, 5, 6, 8, 9];
$users = DB::table('users')
->whereIn('user_id', $listOfUser)
->get();