laravel json column query code example

Example 1: laravel query json

$users = DB::table('users')
                ->whereJsonContains('options->languages', ['en', 'de'])
                ->get();

Example 2: laravel where json array column

whereRaw("JSON_CONTAINS(user_id, '[3]' )")->get();