MySQL-mysql 实现按相似度来排序

Question

我数据库表里某个字段words内容如下：

bog   
dog
dogaral
blog
big
dogma
ago
dogid
echo

Answer 1

 select *from (select *, case when words like '%dog%' then 1
when words like '%og%' then 2
when words like '%g%' then 3
when words like '%o%' then 4 end as rn
from test
where words like '%dog%' or words like '%og%' or words like '%g%' or words like '%o%' ) as k
order by rn;

效果如下。

Answer 2

这种不能用SQL实现吧，近似于搜索引擎的算法，需要先对数据进行分词处理。你可以使用第三方搜索引擎来实现，例如JAVA的Lucene。

Answer 3

 SELECT * from table where word like "%dog%" or word like "%og%" or word like "%g%" or word like "%o%" or word like "%d%"

。。。。