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 votes169 views5 answers
Unique laravel migration
PHP Laravel
0 vote152 views1 answer
Appserviceprovider laravel auth user
PHP Laravel
5 votes151 views2 answers
How to clear session in laravel
PHP Laravel
2 votes165 views3 answers
Laravel Create Custom Artisan Command
PHP
0 vote143 views1 answer
Php post data empty
PHP
0 vote157 views1 answer
Laravel collection reverse
PHP Laravel
1 vote109 views1 answer
Redirect from laravel controller to another link
PHP Laravel
6 votes147 views2 answers
Php does property exist
PHP
2 votes141 views2 answers
Laravel show table columns
PHP Laravel
0 vote141 views1 answer
Codeigniter email print debugger
PHP