Solr Query with LIKE Clause

solr lucene solrnet edismax
Mark Meisel picture Mark Meisel · Jan 17, 2012 · Viewed 29.2k times · Source

I'm working with Solr and I'd like to know if it is possible to have a LIKE clause in the query. For example, I want to know all organizations with "New York" in the title. In SQL, this would be written like Name LIKE 'New York%'.

My question - how do you write a LIKE query in Solr?

I'm using the SolrNet library, if that makes a difference.

Answer

Mauricio Scheffer picture Mauricio Scheffer · Jan 17, 2012

You just search for "New York", but first you need to properly configure your field's analyzer. For example you might want to start with a field type like text_general as defined in the default Solr schema. This field type will tokenize on whitespace and other common word separators, then apply a filter of stopwords, then lowercase the terms in order to make searches case-insensitive.

More information about analyzers in the Solr wiki.

Related questions

How to boost fields in solr

I already have the boost determined before hand. I have a field in the solr index called boost1 . This boost field will have a value from 1 to 10 similar to google PR rank. This is the boost that should be applied …

Read More
solr search for documents where a field doesn't exist

How do I search for those document in a SOLR index which do not contain a specified field?

Read More
Sorting with Multivalued Field in Solr

I Have a Solr index that stores Price in a multivalued field for each Product. I need to sort the result set by Price where the Price is Low to high and High to Low. I try to use sorting …

Read More