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 vote117 views1 answer
How to add php 7.4 in homebrew
PHP
0 vote104 views1 answer
Bcmath php extension in ubuntu
PHP
12 votes146 views5 answers
Laravel transactions
PHP Laravel
0 vote98 views1 answer
String between two strings
PHP
4 votes119 views1 answer
Laravel add utility class
PHP
0 vote204 views2 answers
Array collapse laravel
PHP Laravel
0 vote122 views1 answer
Php estrutura basica
PHP
1 vote151 views1 answer
Codeigniter 3 Configured database connection has cache enabled
PHP CodeIgniter
0 vote108 views1 answer
Yii2 clear schema cache
PHP
0 vote103 views1 answer
Taxonomy_get_children drupal 8
PHP