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 vote131 views1 answer
Invalid_scope 'Custom scopes are not allowed for this request.' okta
PHP
1 vote126 views1 answer
Example code codeigniter seeders
PHP
1 vote121 views1 answer
Laravel storage check file exists
PHP
1 vote131 views1 answer
Create controller codeigniter 3
PHP
0 vote122 views1 answer
Get time ISO 8601 wordpress
PHP
0 vote127 views2 answers
Pagination using AJAX
PHP
16 votes243 views2 answers
Wordpress debug config
PHP Wordpress
0 vote144 views1 answer
Get post by name wordpress
PHP Wordpress
1 vote129 views2 answers
Strtotime format
PHP
0 vote118 views1 answer
Pusher in laravel array_merge(): Argument #2 is not an array
PHP