dp19001
2017-08-02 02:09
浏览 140
已采纳

如何通过Eloquent检索空的json数组?

I have table item which has a JSON column sku_purchase_price. There are some rows like that:

enter image description here

I tried to retrieve those rows from DB by Eloquent:

$items = Item::where('sku_purchase_price', '[]')->get();

but it returns a collection with zero results.

So, how to retrieve those row from DB by Eloquent?

图片转代码服务由CSDN问答提供 功能建议

我的表 item 有一个JSON列 sku_purchase_price 。 有类似的行:

我尝试从DB中检索这些行 Eloquent:

  $ items = Item :: where('sku_purchase_price','[]') - > get(); 
    
 
 

但它会返回一个零结果的集合。

那么,如何通过Eloquent从DB中检索这些行?

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • douxing8939 2017-08-02 02:53
    已采纳

    Um there is something not quite right in your code base earlier on if it's inserting empty arrays.

    You need to find the code that is inserting into this table and check if there is an empty array being created and if there is, pass through an empty string or nothing if it's not a required field.

    However if you want to select them using Eloquent you would do:

    $items = Item::where('sku_purchase_price', '\[\]')->get();
    

    But yes, don't do this, find the actual problem in your code first rather than trying to select empty arrays from the db...

    评论
    解决 无用
    打赏 举报
查看更多回答(1条)

相关推荐 更多相似问题