Laravel JSON query

Laravel query json

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

Source: laravel.com

Laravel JSON Where Query

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

$users = DB::table('users')
                ->where('preferences->dining->meal', 'salad')
                ->get();

Source: laravel.com

Laravel JSON query

$users = DB::table('users')
                ->where('preferences->dining->meal', 'salad')
                ->get();

Source: laravel.com

Similar codes

1 vote400 views1 answer
Operador in laravel
PHP Laravel
0 vote385 views1 answer
Laravel collection flatMap
PHP Laravel
0 vote358 views1 answer
Laravel polymorphic relationship why we need this relation orm,
PHP Laravel
2 votes353 views1 answer
Return back in blade laravel
PHP Laravel
3 votes369 views3 answers
Laravel carbon count days between dates
PHP Laravel
0 vote371 views1 answer
Exclude row from clooection laravel
PHP Laravel
2 votes340 views2 answers
Laravel 5.8 cors
PHP Laravel
0 vote383 views1 answer
Populate old value of dropdown laravel
PHP Laravel
3 votes351 views4 answers
Delete multiple row by model in laravel
PHP Laravel
1 vote321 views2 answers
Laravel check if id in collection
PHP Laravel