Need Help for ES query

Elastic Stack Elasticsearch
1

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

2

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.