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

2 votes191 views3 answers
Laravel check empty string
PHP Laravel
28 votes177 views5 answers
Laravel whereRaw
PHP Laravel
2 votes165 views1 answer
Laravel ever over https
PHP Laravel
0 vote237 views1 answer
Laravel import csv to database
PHP Laravel
0 vote234 views2 answers
Request get query string laravel
PHP Laravel
2 votes204 views2 answers
Laravel forcefill
PHP Laravel
37 votes222 views6 answers
Laravel create or update
PHP Laravel
5 votes187 views2 answers
In laravel date duration validation rule
PHP Laravel
0 vote183 views1 answer
Single row data from table in laravel
PHP Laravel
1 vote192 views3 answers
Delete a migration laravel
PHP Laravel