NGrams are often used in Solr for this case, but they will also add to your index size.
It might be worthwhile to look closely at your user requirements before going ahead and supporting this functionality.... Best Erick 2011/11/1 François Schiettecatte <fschietteca...@gmail.com>: > 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 >>> >> > >
