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

如何通过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?

  • 写回答

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条)

报告相同问题?