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

9 votes160 views6 answers
Get raw query laravel
PHP Laravel
0 vote196 views1 answer
Update function laravel 7
PHP Laravel
2 votes158 views2 answers
Assert file exists laravel
PHP Laravel
0 vote160 views1 answer
Jwt auth laravel auth without password field
PHP Laravel
1 vote172 views1 answer
Laravel number add 0 before
PHP Laravel
4 votes175 views4 answers
Laravel carbon today date format
PHP Laravel
1 vote167 views2 answers
Laravel check if object is empty
PHP Laravel
0 vote153 views2 answers
Count with condition laravel
PHP Laravel
1 vote179 views1 answer
Types of looping directives in laravel
PHP Laravel
1 vote162 views1 answer
Laravel storage check file exists
PHP Laravel