contentJava的博客

转载 MySQL模糊查询，按关键词匹配度排序

以字符串‘t2’为关键字，message为查询字段，提取sql语句如下：select* ,case when message like '%t2%' then (length(message)-length('t2')) end as rn from total where message like '%t2%' order by rn;这个语句的case when 完全可以去掉，修改