Exact replacement of LIKE with MATCH() / QUERY() in SQL query

Welcome!

That'd help if you share a concrete example of what you have and what you'd like to be able to search for. Like a full recreation script as described in About the Elasticsearch category. It will help to better understand what you are doing. Please, try to keep the example as simple as possible.

A full reproduction script is something anyone can copy and paste in Kibana dev console, click on the run button to reproduce your use case. It will help readers to understand, reproduce and if needed fix your problem. It will also most likely help to get a faster answer.

Have a look at the https://elastic.co/community/help page. It contains also lot of useful information on how to ask for help.

In general the answer is to "solve" that problem at index time. But let's discuss this when you share more details.