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 vote165 views1 answer
Laravel collection get
PHP
1 vote159 views1 answer
Insert data using model in laravel 8
PHP
5 votes185 views2 answers
Laravel blade upper case
PHP Laravel
1 vote183 views1 answer
Exponentiation php
PHP
0 vote169 views1 answer
Laravel carbon first day of month
PHP Laravel
3 votes157 views2 answers
Remove cookies php
PHP
0 vote163 views1 answer
Igaster\Laravel Theme\Exceptions\theme Already Exists
PHP
32 votes155 views2 answers
Laravel sample controller
PHP
0 vote192 views1 answer
Laravel imap - Get message attachments
PHP Laravel
12 votes160 views4 answers
Laravel call controller method from another controller
PHP Laravel