MYSQL 实现加权排序

优化一商城列表搜索页，同事发来一篇文章。嗯，搞。加权排序类似于加权平均，有所侧重。在商城中，商品名称，关键词，规格，商品描述等类似于一片片文章。希望名称，关键词的权重高于描述。找到用户更想查询到的数据。SELECT 1 * ( document.w10 + document.w20 + document.w30 ) * ( document.w11 + document.w21 + document.w31 ) AS w, document.* FROM ( SELECT 0, CASE WHEN d.abstracts LIKE '%1%' THEN 2 ELSE 0.1 END AS w10, CASE WHEN d.tags LIKE '%1%' THEN 3 ELSE 0.1 END AS w20, CASE WHEN d.NAME LIKE '%1%' THEN 4 ELSE 0.1 END AS w30, CASE WHEN

MYSQL · 2023-07-07
2022 - 2024 进击的小学生. All Rights Reserved.
Theme Jasmine by Kent Liao