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 vote187 views1 answer
If condition view page of laravel
PHP Laravel
11 votes163 views4 answers
Laravel create resource controller
PHP Laravel
1 vote184 views1 answer
Increment single column laravel
PHP Laravel
17 votes174 views4 answers
Laravel with trashed
PHP Laravel
0 vote161 views1 answer
Laravel model where set fields laravel
PHP Laravel
23 votes172 views6 answers
Laravel logs
PHP Laravel
0 vote176 views2 answers
Laravel santum
PHP Laravel
5 votes207 views5 answers
Laravel composer update
PHP Laravel
0 vote187 views2 answers
View blade not found in laravel
PHP Laravel
0 vote167 views1 answer
Mysqldump is not recognized as an internal or external command laravel
PHP Laravel