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 vote245 views1 answer
Referencing constant in config laravel
PHP Laravel
0 vote257 views2 answers
Laravel collection search
PHP Laravel
1 vote213 views2 answers
Throttle laravel
PHP Laravel
1 vote202 views1 answer
Laravel format number blade
PHP Laravel
1 vote215 views1 answer
Laravel dusk run failed tests
PHP Laravel
0 vote229 views1 answer
Laravel How to access imagen uploaded in storage
PHP Laravel
1 vote228 views1 answer
Bootstrap doesn't work in laravel
PHP Laravel
0 vote207 views1 answer
Laravel db ssh
PHP Laravel
0 vote211 views1 answer
Laravel vu3
PHP Laravel
2 votes221 views4 answers
Laravel hash password check
PHP Laravel