mysql 全文搜索软件_MySQL全文搜索和SOUNDEX

最新推荐文章于 2022-12-15 19:24:47 发布

今忱

最新推荐文章于 2022-12-15 19:24:47 发布

阅读量75

点赞数

文章标签： mysql 全文搜索软件

本文链接：https://blog.csdn.net/weixin_28699983/article/details/113241021

版权

I am trying to implement a first and last name search using full-text search and SOUNDEX (in case if the name is misspelled).

I was trying to do something like

SELECT *

FROM employees

WHERE

MATCH SOUNDEX(first_name, last_name) AGAINST SOUNDEX('John 1969 Ivan')

but this is not a valid syntax.

What I want to achieve, is that when a user types for example "Jon Ivan", the columns

first_name | last_name

----------------------

John Ivan

would match.

Thank you in advance!

解决方案

MySQL tends to fall short when it comes to text searches, fuzzy searches, misspellings, etc. I highly recommend an indexing solution like Solr. Solr supports four different types of phonetic searches: Soundex, RefinedSoundex, Metaphone, and DoubleMetaphone. It has geospatial searching and misspelling searches along with butterfly/butterflies searching. I think you will REALLY be happy with the results you get. It is lightening fast compared to MySQL