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

4 votes299 views2 answers
Laravel migration update table column type
PHP Laravel
0 vote282 views1 answer
Laravel new project command doesn't create vendor
PHP Laravel
1 vote302 views1 answer
Laravel migration add datetime column with default
PHP Laravel
0 vote282 views1 answer
Laravel Auth::logoutOtherDevices
PHP Laravel
2 votes291 views2 answers
Laravel simplexmlelement xml add attribute
PHP Laravel
0 vote241 views2 answers
Laravel blade empty
PHP Laravel
0 vote278 views3 answers
Laravel 'Choice question must have at least 1 choice available.'
PHP Laravel
11 votes250 views5 answers
Resource route laravel
PHP Laravel
0 vote277 views1 answer
Show selected value in dropdown laravel
PHP Laravel
31 votes282 views6 answers
Make model with migration laravel
PHP Laravel