Yii使用 case when 来模糊排序查询
$search_arr=['沙发','床','现代轻奢','新中式'];//越排在前面得关键词,优先模糊排序
$where=[];
$order_by="";
$query = Goods::find()->alias('g')->where([
'g.status' => 1,
'g.is_delete' => 0,
'g.type' => get_plugin_type(),
原创
2021-03-05 16:54:35 ·
223 阅读 ·
1 评论