MySql多个关键字like查询结果按照匹配最多排序：
|
1
|
SELECT * FROM table WHERE `title` LIKE '%关键字1%' OR `title` LIKE '%关键字2%' OR `title` LIKE '%关键字3%' OR `title` LIKE '%关键字4%' ORDER BY ((CASE WHEN `title` LIKE '%关键字1%' then 3 else 0 end)+(CASE WHEN `title` LIKE '%关键字2%' then 1 else 0 end)) DESC LIMIT 0, 4
|
未经允许不得转载：主机百科 » MySql多个关键字like查询结果按照匹配最多排序
蒙公网安备15010502001094号