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 vote179 views1 answer
Get data in array formate in Laravel
PHP Laravel
7 votes138 views4 answers
$errors show this error in laravel
PHP Laravel
0 vote129 views1 answer
Laravel Eloquent, group by month/year
PHP Laravel
0 vote140 views1 answer
Show data from a table in laravel 8
PHP Laravel
2 votes156 views3 answers
Foreach loop laravel
PHP Laravel
1 vote138 views1 answer
Laravel dusk run failed tests
PHP Laravel
0 vote173 views2 answers
Sweet alert confirm box laravel
PHP Laravel
5 votes137 views1 answer
Laravel like foreach
PHP Laravel
8 votes144 views6 answers
Laravel validation date
PHP Laravel
3 votes161 views1 answer
Insert rows in migrations laravel
PHP Laravel