CODEWITHSUNDEEP
lucenesolr
Michael Moussa
Michael Moussa

Reputation: 4297

How can I search on a list of values using Solr/Lucene?

Given the following query:

(field:value1 OR field:value2 OR field:value3 OR ... OR field:value50)

Can this be broken down into something less verbose? Basically I have hundreds of category IDs, and I need to search for items under large groups of category IDs (20-50 at a time). In MySQL, I'd just use field IN(value1, value2, value3) rather than (field = value1 OR field = value2 etc...).

Is there a simpler way for Solr/Lucene?

Upvotes: 43

Views: 52470

Answers (2)

artin2
artin2

Reputation: 146

The accepted answer didn't work for me, but the following format did: +(field:value1 OR field:value2 OR field:value3)

Upvotes: 1

martsraits
martsraits

Reputation: 3015

Use

field:(value1 value2 value3)

or if your default operator is AND then use

field:(value1 OR value2 OR value3)

Upvotes: 104

Related Questions