//TP5 find_in_set用法
$where['parent_store_id'] = $this->parent_store_id;
$where['status'] = 'up';
$where['type'] = 'normal';
$where['deletetime'] = NULL;
$data[$k]['children'] = db('shopro_goods')
->where($where)
->where('find_in_set(8,category_ids)')
->order('weigh asc')->select();
tp5 where查询数据库中的某个字段是否包含某个值,不用like的方法,模糊查询
于 2020-09-07 11:59:10 首次发布