问题描述
我正在与Solr合作，我想知道查询中是否可以有LIKE子句.例如，我想知道标题中带有纽约"的所有组织.在SQL中，它的写法类似于Name LIKE'New York％'.
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%'.
我的问题-如何在Solr中编写LIKE查询?
My question - how do you write a LIKE query in Solr?
如果使用的话，我正在使用SolrNet库.
I'm using the SolrNet library, if that makes a difference.
推荐答案
您仅搜索"New York"，但首先需要正确配置字段的分析器.例如，您可能想以.此字段类型将对空格和其他常见单词分隔符进行标记化，然后应用停用词过滤器，然后对术语进行小写以使搜索不区分大小写.
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.
这篇关于使用LIKE子句进行Solr查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！