What is equivalent query as SQL LIKE clause?


(tanimoto) #1

I'm comparing ES search results with SQL.
ES version is 2.4.2.

Is there exactly same query with SQL LIKE clause?

I use wildcatd with * but it returns lots of similar words, not only exact partial match.

I'm using it in Japanese.


(David Pilato) #2

You need to understand first how elasticsearch is working behind the scene.
I'd encourage you reading https://www.elastic.co/guide/en/elasticsearch/guide/current/mapping-analysis.html

Then, don't use wildcard unless you really have a use case for it.
Use match queries and provide the right analyzer for your use case.


(system) #3

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