Eric, NGrams could you elaborate on that ? -- haven't seen that before.
Thanks. On Tue, Nov 1, 2011 at 11:06 AM, Erick Erickson <erickerick...@gmail.com>wrote: > 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 > >>> > >> > > > > >
