太阳黑子的“ LIKE”查询

sunspot

LIKE

LIKE %q%

 @search = Sunspot.search(User) do |q|
   q.text_fields { with(:company_name).like(params[:q]) }
 end.results

@search = Sunspot.search(User) do |q|
  q.text_fields { with(:company_name).starting_with(params[:q]) }
end.results

sunspot

class StartingWith < Base
  private

  def to_solr_conditional
    \"#{solr_value(@value)}*\"
  end
end

Sunspot.search(User) do |q| 
  q.text_fields { with(:company_name).starting_with(\"sta\")} }
end

=> Sunspot::Search:{:q=>\"*:*\", :fq=>[\"type:User\", \"company_name_text:sta*\"]} 

LIKE %query%

to_solr_conditional

Like

<fieldType name=\"text\" class=\"solr.TextField\" omitNorms=\"false\">
  <analyzer type=\"index\">
    ..
    <filter class=\"solr.EdgeNGramFilterFactory\" minGramSize=\"2\" maxGramSize=\"15\" side=\"front\"/>
    ..
  </analyzer>
</fieldType>