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

5 votes173 views3 answers
Laravel validation time hours minutes format
PHP Laravel
1 vote167 views1 answer
Laravel read file from tmp
PHP Laravel
9 votes150 views3 answers
Laravel with select
PHP Laravel
0 vote167 views1 answer
$request laravel undefined inside function query
PHP Laravel
0 vote142 views1 answer
Laravel get current action name
PHP Laravel
23 votes193 views6 answers
Make auth in laravel 7
PHP Laravel
0 vote158 views2 answers
Laravel filesystem
PHP Laravel
1 vote239 views1 answer
Get all errors view laravel
PHP Laravel
0 vote146 views1 answer
Laravel collection zip
PHP Laravel
0 vote149 views1 answer
Load differenet .env file in laravel
PHP Laravel