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

1 vote278 views2 answers
Laravel collection isNotEmpty
PHP Laravel
1 vote303 views1 answer
Laravel validation types for float
PHP Laravel
0 vote311 views1 answer
Laravel route not calling function of controller
PHP Laravel
3 votes311 views1 answer
Check file size validation laravel
PHP Laravel
2 votes314 views1 answer
Laravel app get locale
PHP Laravel
0 vote322 views2 answers
Create model controller migration factory laravel in one command
PHP Laravel
10 votes324 views2 answers
Laravel collection toArray
PHP Laravel
6 votes314 views4 answers
Laravel previous url
PHP Laravel
1 vote314 views1 answer
Invalid datetime format laravel
PHP Laravel
18 votes316 views6 answers
Install laravel auth
PHP Laravel