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

6 votes176 views3 answers
Php check if string contains url
PHP
0 vote181 views2 answers
Obtener rol de usuario registrado en WordPress
PHP
1 vote139 views1 answer
Laravel request integer
PHP
0 vote174 views1 answer
Httpd.exe: Syntax error on line 186 of C:/Apache24/conf/httpd.conf: Can't locate API module structure `php_module' in file C:/php7.4.27/php7apache2_4.dll: No error
PHP
1 vote198 views1 answer
Php check how much time each instruction takes to complete
PHP
5 votes210 views2 answers
Current loggedin user laravel
PHP Laravel
6 votes179 views1 answer
How to calculate the difference between two dates
PHP
8 votes243 views3 answers
Php time limit
PHP
7 votes195 views6 answers
Create array in php
PHP
31 votes183 views6 answers
Php get client ip
PHP