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 vote125 views1 answer
Laravel factory counter
PHP Laravel
11 votes176 views2 answers
Command laravel for php artisan make :auth
PHP Laravel
0 vote123 views1 answer
Import class route laravel
PHP Laravel
0 vote140 views1 answer
Bu7scador con laravel
PHP Laravel
0 vote123 views1 answer
Laravel collection splice
PHP Laravel
2 votes139 views1 answer
Laravel-ckeditor
PHP Laravel
6 votes133 views2 answers
Laravel check if request has value
PHP Laravel
3 votes226 views2 answers
Two condition in one laravel query
PHP Laravel
0 vote135 views2 answers
How to fix Column not found: 1054 Unknown column 'api_token' in 'where clause' (SQL: select * from `users` where `api_token laravel
PHP Laravel
0 vote192 views1 answer
How to take last entry in database in laravel Method Three
PHP Laravel