whereJson包含Laravel 5.6无法正常工作?

问题描述

$rosters = EventRosters::where('event_id', $event_id)
    ->whereJsonContains('players', $user_id)
    ->whereNull('deleted_at')
    ->get();

上面雄辩的查询似乎仅在'players'json数组中只有一个项目时才起作用.

The eloquent query above seems to only work when there is a single item in the 'players' json array.

存储在数据库中的数据如下所示:[1]与["1","2"]

The data stored in the database looks as follows:[1] vs ["1","2"]

难道whereJsonContains仅在数据库中看到[1]时起作用，而不是在看到["1","2"]时不起作用吗?

Is there a reason the whereJsonContains is only working when it sees [1] in the db but not when it sees ["1","2"] ?

我对Laravel来说还很陌生，并且一直在为此而苦苦挣扎.

I am pretty new to Laravel and have been struggling with this one a bit.

推荐答案

数据类型必须匹配:

// [1, 2]
->whereJsonContains('players', 1)   // Works.
->whereJsonContains('players', '1') // Doesn't work.

// ["1", "2"]
->whereJsonContains('players', '1') // Works.
->whereJsonContains('players', 1)   // Doesn't work.

这篇关于whereJson包含Laravel 5.6无法正常工作?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！