Where Clauses: JSON Where Clauses

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

$users = DB::table('users')
                ->where('preferences->dining->meal', 'salad')
                ->get();
$users = DB::table('users')
                ->whereJsonContains('options->languages', 'en')
                ->get();
$users = DB::table('users')
                ->whereJsonContains('options->languages', ['en', 'de'])
                ->get();
$users = DB::table('users')
                ->whereJsonLength('options->languages', 0)
                ->get();

$users = DB::table('users')
                ->whereJsonLength('options->languages', '>', 1)
                ->get();

Where Clauses: JSON Where Clauses — Structure map

Clickable & Draggable!

Where Clauses: JSON Where Clauses — Related pages: