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 vote91 views1 answer
Tinker colorful
PHP
0 vote98 views1 answer
Verify laravel string must be null
PHP
0 vote131 views1 answer
How to get today week month ad year data in eloquent
PHP
0 vote98 views1 answer
Php check if non-object
PHP
3 votes128 views2 answers
Return last inserted id in laravel
PHP
4 votes216 views1 answer
413 error laravel
PHP Laravel
6 votes88 views3 answers
Laravel bootstrap auth scaffolding
PHP
0 vote98 views1 answer
Php signature capture
PHP
0 vote92 views1 answer
Laravel enable mysql logging
PHP
0 vote90 views1 answer
How to loop array in laravel
PHP