Kuli Good point about just tokenizing the fields :)
I ran a couple of tests to double-check my understanding and you can have a wildcard operator at either or both ends of a term. Adding ReversedWildcardFilterFactory to your field analyzer will make leading wildcard searches a lot faster of course but at the expense of index size. Cheers François On Nov 1, 2011, at 9:07 AM, Michael Kuhlmann wrote: > Hi, > > this is not exactly true. In Solr, you can't have the wildcard operator on > both sides of the operator. > > However, you can tokenize your fields and simply query for "Solr". This is > what's Solr made for. :) > > -Kuli > > Am 01.11.2011 13:24, schrieb François Schiettecatte: >> Arshad >> >> Actually it is available, you need to use the ReversedWildcardFilterFactory >> which I am sure you can Google for. >> >> Solr and SQL address different problem sets with some overlaps but there are >> significant differences between the two technologies. Actually '%Solr%' is a >> worse case for SQL but handled quite elegantly in Solr. >> >> Hope this helps! >> >> Cheers >> >> François >> >> >> On Nov 1, 2011, at 7:46 AM, arshad ansari wrote: >> >>> Hi, >>> >>> Is SQL Like operator feature available in Apache Solr Just like we have it >>> in SQL. >>> >>> SQL example below - >>> >>> *Select * from Employee where employee_name like '%Solr%'* >>> >>> If not is it a Bug with Solr. If this feature available, please tell the >>> examples available. >>> >>> Thanks! >>> >>> -- >>> Best Regards, >>> Arshad >> >
