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

49 votes434 views6 answers
Join in laravel
PHP Laravel
1 vote310 views2 answers
Laravel select columns
PHP Laravel
0 vote344 views2 answers
Curl post laravel
PHP Laravel
24 votes311 views6 answers
Laravel create method
PHP Laravel
2 votes324 views3 answers
Laravel check if field has changed
PHP Laravel
0 vote325 views1 answer
How to get a particular column in laravel 8
PHP Laravel
0 vote342 views1 answer
Laravel extends if
PHP Laravel
12 votes301 views6 answers
Run seeder in migration laravel
PHP Laravel
0 vote316 views2 answers
How do we calculate average in laravel 8
PHP Laravel
13 votes307 views6 answers
Laravel delete
PHP Laravel