Multi word partial search

[gibsmds]

hi,
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%')

[dadoonet (David Pilato)]

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

[gibsmds]

thank,Its working fine