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

lucene solr
Michael Moussa picture Michael Moussa · Apr 10, 2010 · Viewed 38.8k times · Source

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?

Answer

martsraits picture martsraits · Apr 10, 2010

Use

field:(value1 value2 value3)

or if your default operator is AND then use

field:(value1 OR value2 OR value3)

Related questions

Solr vs. ElasticSearch

What are the core architectural differences between these technologies? Also, what use cases are generally more appropriate for each?

Read More
ElasticSearch, Sphinx, Lucene, Solr, Xapian. Which fits for which usage?

I'm currently looking at other search methods rather than having a huge SQL query. I saw elasticsearch recently and played with whoosh (a Python implementation of a search engine). Can you give reasons for your choice(s)?

Read More
using OR and NOT in solr query

I'm working on a solr query similar to the following: ((myField:superneat AND myOtherField:somethingElse) OR NOT myField:superneat) When running this, no results are returned. Using criteria on either side of the OR NOT returns results that I'd expect …

Read More