select * from `table`
where title like '%美食%' or title like '%成都%' or title like '%好吃%'
order by
(
(case when title like '%美食%' then 1 else 0 end)+
(case when title like '%成都%' then 1 else 0 end)+
(case when title like '%好吃%' then 1 else 0 end)
)
desc
;
/* 对关键词匹配的个数越多,排在越前 */
where title like '%美食%' or title like '%成都%' or title like '%好吃%'
order by
(
(case when title like '%美食%' then 1 else 0 end)+
(case when title like '%成都%' then 1 else 0 end)+
(case when title like '%好吃%' then 1 else 0 end)
)
desc
;
/* 对关键词匹配的个数越多,排在越前 */
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货