/PHP/Laravel where json array column

Laravel where json array column

Laravel where json array column

->whereJsonContains('user_id', 3)

0

Source: laracasts.com

Laravel where json array column

whereRaw("JSON_CONTAINS(user_id, '[3]' )")->get();

0

Source: laracasts.com

Laravel where json array column

$listOfUser = [1, 3, 5, 6, 8, 9];

$users = DB::table('users')
                    ->whereIn('user_id', $listOfUser)
                    ->get();

0

Source: laracasts.com

Similar codes

21 votes135 views3 answers
Start server cmd php
PHP
14 votes113 views4 answers
Php get current domain
PHP
-1 vote141 views4 answers
How to include file in laravel blade
PHP
1 vote112 views1 answer
How to change laravel 8 login credentials
PHP Laravel
2 votes109 views3 answers
Write a php program to print hello world
PHP
0 vote114 views1 answer
Wordpress wp_enqueue_script footer
PHP Wordpress
0 vote102 views2 answers
Wordpress profile queries
PHP
0 vote96 views2 answers
Laravel storage link without command line
PHP
0 vote103 views2 answers
Concat in where clause laravel query builder
PHP
0 vote113 views1 answer
Igaster\Laravel Theme\Exceptions\theme Already Exists
PHP

Share