Partial full-text search

(Artem Grechka) #1

Hi guys,

I’m doing a tutorial and cannot figure out how I can do a partial full-text search. Let’s say I would like to find “Michael” by “mic” or “Artyom” by “art”. Is it possible?


(Daniel Mai) #2

(Here’s the reply I gave to you on Slack.)

Partial word search can be done with the trigram regular expression index.

Full text search searches for words based on stemming and stop words and tries to understand the language enough so that, for example, a search for “runs” returns results for “run” and “running”.