框架:Yii2.0
字段:goods_detail
内容:[{“goods_name”:"\u6d4b\u8bd5\uff08\u52ff\u62cd\uff09",“goods_qty”:1,“goods_price”:1,“goods_img”:""}]
期望:搜索”测试“ 可以把该记录搜出来
方法:
$value = "测试";
$newValue = str_replace('\\','_', json_encode($value));
$where = " goods_detail like '%" . $newValue . "%'";
$where = str_replace("\"", "", $where);
$rst = static::find()->where($where);