# In Kibana how to do a text search with multiple contains

**URL:** https://discuss.elastic.co/t/in-kibana-how-to-do-a-text-search-with-multiple-contains/109867
**Category:** Kibana
**Created:** [December 1, 2017, 3:00am UTC](https://discuss.elastic.co/t/in-kibana-how-to-do-a-text-search-with-multiple-contains/109867 "2017-12-01T03:00:31Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Vivek\_Menon](https://avatars.discourse-cdn.com/v4/letter/v/ce7236/32.png) [@Vivek\_Menon](https://discuss.elastic.co/u/Vivek_Menon)
#### Post date: [December 1, 2017, 3:00am UTC](https://discuss.elastic.co/t/in-kibana-how-to-do-a-text-search-with-multiple-contains/109867/1 "2017-12-01T03:00:31Z")

</div>

On the kibana UI if I want to search the term car in text on a field named message I would do

message: "%car%"

that works.

If I want to find text that contains both car and bike, I would try  
message:"%car%bike%"

but that did not work.

I also tried

message: _car_bike\*

that didnt work either.

What the right way to do this?

---

<div class="post-metadata">

### Author: ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)
#### Post date: [December 1, 2017, 8:53pm UTC](https://discuss.elastic.co/t/in-kibana-how-to-do-a-text-search-with-multiple-contains/109867/2 "2017-12-01T20:53:36Z")

</div>

Hi Vivek,

If you just enter 2 words in the Discover query bar with a space between them, you'll get results where any of the fields in the docs contain either of those words;

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/2/a294ce79fbd939b98c4e3aa2373b7c90d3899441.png)

If you want to be specific on which fields should be searched you can list them (again with a space between);

So this finds docs where `@message:uploads OR extension:jpg` (the default is OR)

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

And this finds that meet both conditions; `@message:uploads AND extension:jpg`

Regards,  
Lee

---

<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: [December 29, 2017, 8:53pm UTC](https://discuss.elastic.co/t/in-kibana-how-to-do-a-text-search-with-multiple-contains/109867/3 "2017-12-29T20:53:50Z")

</div>

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