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

**URL:** <https://discuss.elastic.co/t/exact-replacement-of-like-with-match-query-in-sql-query/349134>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-sql\
**Created:** [December 12, 2023, 10:35am UTC](https://discuss.elastic.co/t/exact-replacement-of-like-with-match-query-in-sql-query/349134 "2023-12-12T10:35:29Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [December 12, 2023, 11:13am UTC](https://discuss.elastic.co/t/exact-replacement-of-like-with-match-query-in-sql-query/349134/2 "2023-12-12T11:13:21Z")

</div>

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](https://discuss.elastic.co/t/about-the-elasticsearch-category/21). 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](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.

---

_[View the full topic](https://discuss.elastic.co/t/exact-replacement-of-like-with-match-query-in-sql-query/349134)._