laravel json column code example

Example 1: laravel query json

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

Example 2: laravel where json array column

->whereJsonContains('user_id', 3)

Example 3: laravel where json array column

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

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

Example 4: laravel where json array column

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

Example 5: laravel json eloquent

protected $casts = [
    'birthday' => 'date:Y-m-d',
    'joined_at' => 'datetime:Y-m-d H:00',
];