# DSL Query - Compare columns of different Index

**URL:** <https://discuss.elastic.co/t/dsl-query-compare-columns-of-different-index/91190>\
**Category:** Elasticsearch\
**Created:** [June 28, 2017, 8:58pm UTC](https://discuss.elastic.co/t/dsl-query-compare-columns-of-different-index/91190 "2017-06-28T20:58:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aj.murciah](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@aj.murciah](https://discuss.elastic.co/u/aj.murciah)\
**Post date:** [June 28, 2017, 8:58pm UTC](https://discuss.elastic.co/t/dsl-query-compare-columns-of-different-index/91190/1 "2017-06-28T20:58:43Z")

</div>

Hi,  
I need to compare the information of two columns stored in different index.

For example IndexA.Column = IndexB.Column

I try with the following sentence but is wrong:

{  
"query": {  
"match" : {  
"account\_name" : "user\_name"  
}  
}  
}

Can someone help me!

Regards

---

<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:** [June 29, 2017, 6:01am UTC](https://discuss.elastic.co/t/dsl-query-compare-columns-of-different-index/91190/2 "2017-06-29T06:01:19Z")

</div>

Same question as you already asked at

> [@DSL Query: LIKE Condition of SQL](https://discuss.elastic.co/t/dsl-query-like-condition-of-sql/91193):
>
> Hi Basically I need to perform a search similar to LIKE condition in SQL. Ex. Index.ColumnA LIKE Index.ColumnX In other words I need to verify if ColumnA contains or match with Column B. It's important mention that it is not neccesary that both columns have be equals. Regards

Don't open multiple threads about the same subject please.

---

<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:** [July 27, 2017, 6:01am UTC](https://discuss.elastic.co/t/dsl-query-compare-columns-of-different-index/91190/3 "2017-07-27T06:01:19Z")

</div>

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