/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

0 vote312 views1 answer
How to wp create post type in wordpress
PHP Wordpress
0 vote286 views1 answer
Laravel get fillable attributes
PHP Laravel
3 votes240 views2 answers
Seconds to minutes php
PHP
0 vote261 views2 answers
How to separate date and time in laravel
PHP
1 vote274 views1 answer
How to return with open model popup in laravel
PHP Laravel
0 vote261 views1 answer
"customer" attribute not getting saved from admin magento 2
PHP
2 votes234 views5 answers
Laravel installation in windows
PHP Laravel
0 vote274 views2 answers
Remove slashes from json php
PHP
7 votes307 views3 answers
Wordpress custom loop
PHP Wordpress
0 vote249 views1 answer
Symfony form get errors
PHP

Share