I created a fuzzy search in C# for a PostgreSQL database using the similarity()
function from the pg_trgm
module. Now I want to port this search to a MySQL database, but MySQL has no similar trigram functionality.
Is there a way to import the pg-trgm module from PostgreSQL in MySQL or is there a similar implementation of Trigrams for MySQL?
Unfortunately I was not able to find any satisfying implementation yet.
I am reluctant to use a external search engine like Solr due to the effort of installation, maintenance and becoming acquainted with the syntax and configuration.
I know this question is old, but I got here Google searching for this and there is a bit of new information I also found.
As of Mysql 5.7.6, there is built in support for using nGram in full text searches.
Mysql team article regarding ngram searches
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With