# Search working only for case sensitive data while using SQL-ES LIKE

**URL:** <https://discuss.elastic.co/t/search-working-only-for-case-sensitive-data-while-using-sql-es-like/284646>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-sql\
**Created:** [September 20, 2021, 6:02pm UTC](https://discuss.elastic.co/t/search-working-only-for-case-sensitive-data-while-using-sql-es-like/284646 "2021-09-20T18:02:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sammeta\_David\_Raju](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sammeta_david_raju/32/50466_2.png) [@Sammeta\_David\_Raju](https://discuss.elastic.co/u/Sammeta_David_Raju)\
**Post date:** [September 20, 2021, 6:02pm UTC](https://discuss.elastic.co/t/search-working-only-for-case-sensitive-data-while-using-sql-es-like/284646/1 "2021-09-20T18:02:04Z")

</div>

Hi ,

I am trying to search a Text field using SQL-ES with LIKE here is the sample code

```auto
GET /_sql
{
"query":""select * from indexname where customer LIKE '%AR-D'"
}

```

here I am getting resultset only AR-D ,but i want all ar-D,AR-d....etc

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [September 21, 2021, 6:38am UTC](https://discuss.elastic.co/t/search-working-only-for-case-sensitive-data-while-using-sql-es-like/284646/2 "2021-09-21T06:38:55Z")

</div>

For `text` fields, it's recommended you use the full-text search functions ES SQL supports: [Full-Text Search Functions | Elasticsearch Guide [7.x] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/7.x/sql-functions-search.html)

---

<div class="post-metadata">

**Author:** ![Sammeta\_David\_Raju](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sammeta_david_raju/32/50466_2.png) [@Sammeta\_David\_Raju](https://discuss.elastic.co/u/Sammeta_David_Raju)\
**Post date:** [September 21, 2021, 7:19am UTC](https://discuss.elastic.co/t/search-working-only-for-case-sensitive-data-while-using-sql-es-like/284646/3 "2021-09-21T07:19:13Z")

</div>

Hi @Andrei_Stefan ,  
Thank you

```auto
here these full text search is giving me result set which contains AR as words i,e
CSV-AR,DVR-AR...etc .
But I want only records with AR-D
I am using 7.3.2 version of ES and default analyzer

```

---

<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:** [October 19, 2021, 7:19am UTC](https://discuss.elastic.co/t/search-working-only-for-case-sensitive-data-while-using-sql-es-like/284646/4 "2021-10-19T07:19:17Z")

</div>

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