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 vote141 views1 answer
Laravel Secured Password
PHP Laravel
5 votes164 views5 answers
Table drop foreign php laravel
PHP Laravel
0 vote190 views1 answer
Laravel joins eloquent model
PHP Laravel
0 vote170 views1 answer
Tinyinteger laravel +size
PHP Laravel
0 vote176 views2 answers
DB::raw update query in laravel
PHP Laravel
0 vote151 views1 answer
Laravel collection reverse
PHP Laravel
33 votes202 views6 answers
Laravel carbon
PHP Laravel
-1 vote151 views1 answer
Laravel hide columns
PHP Laravel
0 vote176 views3 answers
Database and files backup laravel
PHP Laravel
1 vote144 views1 answer
Pass model in function laravel
PHP Laravel