What is equivalent query as SQL LIKE clause?

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.

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.

1 Like

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