Need Help for ES query

I want to know the respective query in elastic search for a SQl query with LIKE in where clause as follows:

  1. WHERE LIKE 'brown fox%'
  2. WHERE LIKE '%brown fox%'
  3. WHERE LIKE '%brown fox'

Thanks

Hey @Kalyan_Dey,

May I suggest the Elasticsearch SQL translate API for this? For a certain index, you could run your WHERE LIKE .... query in the translate API and it will give you an Elasticsearch _search request instead. I'm not saying it will be the best fit for your mapping and query, but it will get you started with something to experiment with.

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