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

16 votes124 views6 answers
Laravel run migration
PHP
0 vote170 views1 answer
Laravel update single field
PHP Laravel
0 vote134 views1 answer
How to on debug on wp
PHP
2 votes147 views1 answer
Laravel pivot table model
PHP Laravel
0 vote147 views1 answer
Foreach empty laravel
PHP Laravel
0 vote146 views1 answer
Laravel take value from different array by key
PHP Laravel
3 votes202 views2 answers
How to get file extension in laravel
PHP
0 vote162 views1 answer
Wordpress use jquery in plugin
PHP
3 votes139 views1 answer
Events.js:174 error discord.js
PHP
0 vote137 views2 answers
Comment split une chaine de caratere en php
PHP