MYSQL求一个类似搜索引擎的搜索语句？

[fengshuo850420]

需求：A里面有字段a(VARCHAR)，前台传入字符串aa，使用aa去进行模糊匹配，按照相似度进行排序，SQL应该怎么写？

[hongmei85]

https://zhidao.baidu.com/question/163677345.html

[hongmei85]

https://zhidao.baidu.com/question/163677345.html

[fengshuo850420]

下面这个sql能够解决基本问题，不过dog这个字符串怎么截取成为：dog,do,og,g.o呢？ 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;