# How could I have MySQL IN clause within my elasticsearch query?
**URL:** https://discuss.elastic.co/t/how-could-i-have-mysql-in-clause-within-my-elasticsearch-query/61764
**Category:** Elasticsearch
**Created:** [September 29, 2016, 5:22am UTC](https://discuss.elastic.co/t/how-could-i-have-mysql-in-clause-within-my-elasticsearch-query/61764 "2016-09-29T05:22:54Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Kulasangar\_Gowrisang](https://discuss.elastic.co/u/Kulasangar_Gowrisang)
#### Post date: [September 29, 2016, 5:22am UTC](https://discuss.elastic.co/t/how-could-i-have-mysql-in-clause-within-my-elasticsearch-query/61764/1 "2016-09-29T05:22:54Z")
I'm trying perform an elasticsearch query as a GET request in order pull data from the index which I created. The data which is in the index is, a table from MySQL DB, configured though logstash.
Here is my request without the IN clause:
**[http://localhost:9200/response\_summary/\_search?q=myquery](http://localhost:9200/response_summary/_search?q=myquery)**
In the above, I should be able to append `AND responseCode IN (401,403)`. I tried giving it a search on the web, but couldn't find any solutions.
Any help could be appreaciated.
---
### Author:  [@Kulasangar\_Gowrisang](https://discuss.elastic.co/u/Kulasangar_Gowrisang)
#### Post date: [September 29, 2016, 5:32am UTC](https://discuss.elastic.co/t/how-could-i-have-mysql-in-clause-within-my-elasticsearch-query/61764/2 "2016-09-29T05:32:41Z")
Found the solution, I've appended it at the end:
**[http://localhost:9200/response\_summary/\_search?q=myquery+responsecode:(401+404)](http://localhost:9200/response_summary/_search?q=myquery+responsecode:(401+404))**
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [September 29, 2016, 6:19am UTC](https://discuss.elastic.co/t/how-could-i-have-mysql-in-clause-within-my-elasticsearch-query/61764/3 "2016-09-29T06:19:07Z")
I'd recommend using the query DSL instead.
You can clearly express what you want to do.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 5, 2017, 10:16pm UTC](https://discuss.elastic.co/t/how-could-i-have-mysql-in-clause-within-my-elasticsearch-query/61764/4 "2017-07-05T22:16:16Z")