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 vote346 views1 answer
Install phpredis MAC OSX
PHP
0 vote318 views1 answer
Get page name wp
PHP
2 votes447 views6 answers
Composer create project laravel 7
PHP
0 vote331 views1 answer
Laravel faker title
PHP
1 vote390 views1 answer
$conn php
PHP
8 votes361 views2 answers
How to check even or odd number in php
PHP
2 votes414 views2 answers
Laravel now date
PHP Laravel
0 vote321 views2 answers
HTML and PHP enquiry form
PHP
1 vote357 views3 answers
Laravel invoice toturial
PHP Laravel
0 vote335 views1 answer
Laravel mysql specified key was too long
PHP