# Case insensitive search with fieldname.keyword

**URL:** <https://discuss.elastic.co/t/case-insensitive-search-with-fieldname-keyword/117994>\
**Category:** Elasticsearch\
**Created:** [February 1, 2018, 10:32am UTC](https://discuss.elastic.co/t/case-insensitive-search-with-fieldname-keyword/117994 "2018-02-01T10:32:18Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![aneesh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aneesh/32/37819_2.png) [@aneesh](https://discuss.elastic.co/u/aneesh)\
**Post date:** [February 1, 2018, 10:32am UTC](https://discuss.elastic.co/t/case-insensitive-search-with-fieldname-keyword/117994/1 "2018-02-01T10:32:18Z")

</div>

Hi

I need search results with exact matching of word but it should be case insensitive.

"Abc","ABC","aBc" : all should come in result  
but  
"Abc Def", "ABC FG" : should not come (do not search for substring)

```
GET people/people/_search
{
  "query": {
    "bool": { 
      "must":[
          {
              "match": {
                "city.keyword": "York"
              }
          }
      ]   
    }
  }
}

```

Thanks  
Aneesh L

---

<div class="post-metadata">

**Author:** ![val](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/val/32/138203_2.png) [@val](https://discuss.elastic.co/u/val)\
**Post date:** [February 1, 2018, 10:36am UTC](https://discuss.elastic.co/t/case-insensitive-search-with-fieldname-keyword/117994/2 "2018-02-01T10:36:01Z")

</div>

You should try using `match_phrase` instead on the `city` field

```
GET people/people/_search
{
  "query": {
    "bool": { 
      "must":[
          {
              "match_phrase": {
                "city": "York"
              }
          }
      ]   
    }
  }
}
```

---

<div class="post-metadata">

**Author:** ![aneesh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aneesh/32/37819_2.png) [@aneesh](https://discuss.elastic.co/u/aneesh)\
**Post date:** [February 1, 2018, 10:43am UTC](https://discuss.elastic.co/t/case-insensitive-search-with-fieldname-keyword/117994/3 "2018-02-01T10:43:23Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/b/d/bd5d7ef7f18a5a31e4233e5e95cfda9c2c284179.png)

But its giving New York also  
I need only whole word match

---

<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:** [February 1, 2018, 10:45am UTC](https://discuss.elastic.co/t/case-insensitive-search-with-fieldname-keyword/117994/4 "2018-02-01T10:45:12Z")

</div>

I'd use a lowercase based analyzer in that case.

---

<div class="post-metadata">

**Author:** ![aneesh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aneesh/32/37819_2.png) [@aneesh](https://discuss.elastic.co/u/aneesh)\
**Post date:** [February 1, 2018, 10:47am UTC](https://discuss.elastic.co/t/case-insensitive-search-with-fieldname-keyword/117994/5 "2018-02-01T10:47:45Z")

</div>

You mean a settings/mapping change?

---

<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:** [February 1, 2018, 2:49pm UTC](https://discuss.elastic.co/t/case-insensitive-search-with-fieldname-keyword/117994/6 "2018-02-01T14:49:24Z")

</div>

Yes.

---

<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:** [March 1, 2018, 2:49pm UTC](https://discuss.elastic.co/t/case-insensitive-search-with-fieldname-keyword/117994/7 "2018-03-01T14:49:30Z")

</div>

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