# Term query on multiple fields based on a wildcard notation
**URL:** https://discuss.elastic.co/t/term-query-on-multiple-fields-based-on-a-wildcard-notation/183620
**Category:** Elasticsearch
**Created:** [May 30, 2019, 10:04pm UTC](https://discuss.elastic.co/t/term-query-on-multiple-fields-based-on-a-wildcard-notation/183620 "2019-05-30T22:04:03Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@marb](https://discuss.elastic.co/u/marb)
#### Post date: [May 30, 2019, 10:04pm UTC](https://discuss.elastic.co/t/term-query-on-multiple-fields-based-on-a-wildcard-notation/183620/1 "2019-05-30T22:04:03Z")
Hi all,
I'm trying to do an exact match on an unknown number of fields.
I know that we can do a fulltext search on a set of fields using a multi\_match like:
{
"multi\_match": {
"fields":"fieldprefix\_\* ",
"query": "foo"
}
}
Now I would like to do the equivalent with a term query:
{
"term": {
"fields":"fieldprefix\_\* ",
"query": "foo"
}
}
Obviously, this notation is not supported as well as
{
"term": {
"fieldprefix\_\*": "foo"
}
}
So what is the closest syntax to achieve this use case? (of course, I don't know the name of all the fields starting by "fieldprefix\_"
Thanks
---
### Author:  [@marb](https://discuss.elastic.co/u/marb)
#### Post date: [June 3, 2019, 11:28pm UTC](https://discuss.elastic.co/t/term-query-on-multiple-fields-based-on-a-wildcard-notation/183620/2 "2019-06-03T23:28:18Z")
bump up this one.
Does it mean there is no equivalent for an exact match?
---
### Author:  [@abdon](https://discuss.elastic.co/u/abdon)
#### Post date: [June 5, 2019, 12:43pm UTC](https://discuss.elastic.co/t/term-query-on-multiple-fields-based-on-a-wildcard-notation/183620/3 "2019-06-05T12:43:54Z")
You could override the analyzer in the query to use the keyword analyzer. That way, you'll be using the multi\_match query to search for exact terms:
```auto
{
"query": {
"multi_match": {
"fields": "fieldprefix_*",
"query": "foo",
"analyzer": "keyword"
}
}
}
```
---
### Author:  [@marb](https://discuss.elastic.co/u/marb)
#### Post date: [June 12, 2019, 5:10am UTC](https://discuss.elastic.co/t/term-query-on-multiple-fields-based-on-a-wildcard-notation/183620/4 "2019-06-12T05:10:45Z")
thank you that's a very good idea and it indeed works.
So one more questions, how would you do the equivalent with terms?
_terms_ accepts a list of values and not a single value.
Would you just use a _should_ clause to test each individual value?
Thx
---
### Author:  [@abdon](https://discuss.elastic.co/u/abdon)
#### Post date: [June 12, 2019, 8:20am UTC](https://discuss.elastic.co/t/term-query-on-multiple-fields-based-on-a-wildcard-notation/183620/5 "2019-06-12T08:20:19Z")
Yeah, a bool query with a number of queries in a should clause is probably the best way.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 10, 2019, 8:20am UTC](https://discuss.elastic.co/t/term-query-on-multiple-fields-based-on-a-wildcard-notation/183620/6 "2019-07-10T08:20:24Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.