thinkphp 多条件模糊搜索结果，按照最佳匹配度排序，使用LOCATE函数

最新推荐文章于 2021-04-08 05:33:26 发布

weixin_30547797

最新推荐文章于 2021-04-08 05:33:26 发布

阅读量473

点赞数

文章标签： php

原文链接：http://www.cnblogs.com/yuuje/p/11024519.html

版权

 1 //获取筛选参数
 2 $params = Request()->only(['keywords','brand_id', 'cat_id']);
 3 
 4 $where = "brand_id = " . $params['brand_id']
 5 
 6 $where .= " or (goods_name like '%" . $params['keywords'] . "%' or goods_sn like '%" . $params['keywords'] . "%' or desc_title like '%" . $params['keywords'] . "%' or keywords like '%" . $params['keywords'] . "%'))";
 7 
 8 $field = 'goods_id,brand_id,goods_name,desc_title,keywords'; 
 9 
10 $field .=(',LOCATE("'.$params['keywords'].'",goods_name) as gIndex');//使用LOCATE函数 
11 
12 $goods_list = (new GoodsModel())->get_goods_lists($field, $where, $order);

//使用LOCATE函数，查询出来的结果以搜索 keywords ='方轴' 排序

SELECT goods_name,desc_title,sort_order,LOCATE('方轴',goods_name) as gIndex FROM goods WHERE goods_name LIKE '%方轴%' OR desc_title LIKE '%方轴%' OR keywords LIKE '%方轴%' ORDER BY gIndex DESC