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

8 votes203 views3 answers
Check for an existing user laravel eloquent
PHP Laravel
2 votes204 views1 answer
How get all files name in one folder in laravel
PHP Laravel
-2 votes190 views2 answers
Carbon laravel d m y to y-m-d
PHP Laravel
0 vote210 views1 answer
Laravel str_pad Consecutivo
PHP Laravel
0 vote182 views2 answers
Laravel collection collect
PHP Laravel
1 vote201 views1 answer
Convert php array to javascript json laravel
PHP Laravel
1 vote188 views4 answers
Laravel create multiple rows
PHP Laravel
53 votes236 views6 answers
Check laravel version
PHP Laravel
1 vote218 views1 answer
Break and continue in laravel
PHP Laravel
0 vote193 views1 answer
Laravel lang with parameter
PHP Laravel