本文介绍了whereJsonContains Laravel 5.6 不起作用?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
$rosters = EventRosters::where('event_id', $event_id)
->whereJsonContains('players', $user_id)
->whereNull('deleted_at')
->get();
上面的 eloquent 查询似乎只在 'players' json 数组中有单个项目时才有效.
The eloquent query above seems to only work when there is a single item in the 'players' json array.
存储在数据库中的数据如下所示:[1] vs ["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.
这篇关于whereJsonContains Laravel 5.6 不起作用?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！