# How can I use standard SQL on text fields of elastic without using the specials SQL elasticSearch operators?

**URL:** <https://discuss.elastic.co/t/how-can-i-use-standard-sql-on-text-fields-of-elastic-without-using-the-specials-sql-elasticsearch-operators/299057>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-sql\
**Created:** [March 8, 2022, 8:47am UTC](https://discuss.elastic.co/t/how-can-i-use-standard-sql-on-text-fields-of-elastic-without-using-the-specials-sql-elasticsearch-operators/299057 "2022-03-08T08:47:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shiranOren](https://avatars.discourse-cdn.com/v4/letter/s/9e8a1a/32.png) [@shiranOren](https://discuss.elastic.co/u/shiranOren)\
**Post date:** [March 8, 2022, 8:47am UTC](https://discuss.elastic.co/t/how-can-i-use-standard-sql-on-text-fields-of-elastic-without-using-the-specials-sql-elasticsearch-operators/299057/1 "2022-03-08T08:47:36Z")

</div>

I would like to create SQL query on some text field (not keyword) for example "name" field and send that query to elastic server.

my problem is that I need to use the standard SQL language (not the MATCH and QUERY operators which are specials for elastic SQL) of text fields.

when I tried to use JDBC driver or when I tried to use high-level-java-client with "LIKE" operator I got the following error

```auto
  "No keyword/multi-field defined exact matches for [name]; define one or use MATCH/QUERY instead"

```

I also tried to use the translate API of Elasticsearch- but even there I couldn't use the "LIKE" operator on text fields only on keyword fields.

does anyone have any solution for me? I want to use the LIKE operator on text fields instead of the full text operators which are unique to elastic sql.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 5, 2022, 8:48am UTC](https://discuss.elastic.co/t/how-can-i-use-standard-sql-on-text-fields-of-elastic-without-using-the-specials-sql-elasticsearch-operators/299057/2 "2022-04-05T08:48:26Z")

</div>

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