Multi word partial search

(Gibs Mds) #1

i am very new to the Elastic search.
Like to know how to search partial multi word search.
ex :
My document
"title":"harry porter"

i need this document with search with following string
1.)har por
sql query (select * from books where title like '%har%' or title like '%por%')

(David Pilato) #2

You need to change the analyzer for your field and use a ngram based one.

(Gibs Mds) #3

thank,Its working fine

(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.