Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there a Trigram functionality like pg_trgm (PostgreSQL) for MySQL?

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.

like image 469
ischas Avatar asked Aug 07 '13 15:08

ischas


1 Answers

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

like image 190
Reid Johnson Avatar answered Nov 12 '22 20:11

Reid Johnson