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

0 vote201 views1 answer
Composer require laravelcollection
PHP Laravel
18 votes218 views4 answers
Use if in laravel blade
PHP Laravel
22 votes244 views5 answers
Get logged user id laravel
PHP Laravel
49 votes242 views6 answers
Laravel add column to existing table
PHP Laravel
1 vote258 views1 answer
How to override default name for apiresourc route in laravel
PHP Laravel
1 vote246 views2 answers
Set nav link active on the basis of route laravel 8
PHP Laravel
3 votes260 views2 answers
Associate laravel
PHP Laravel
2 votes214 views2 answers
Bootstrap pagination laravel
PHP Laravel
1 vote235 views1 answer
Laravel map array
PHP Laravel
9 votes267 views4 answers
Laravel group route controller
PHP Laravel