Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
Received-SPF: pass (athena.apache.org: domain of fschiettecatte@gmail.com
 designates 209.85.220.176 as permitted sender)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Apple Message framework v1251.1)
Subject: Re: Is SQL Like operator feature available in Apache Solr query
From: =?iso-8859-1?Q?Fran=E7ois_Schiettecatte?= <fschiettecatte@gmail.com>
In-Reply-To: 
 <CAMQGjvmTdxyXHcaYZTmbLYk-HwcLV+E9iv-bTABMBZR6ghvr2Q@mail.gmail.com>
Date: Tue, 1 Nov 2011 08:24:37 -0400
Content-Transfer-Encoding: quoted-printable
Message-Id: <8417F190-B1AC-4D40-A6C2-F346F40AEB3D@gmail.com>
References: 
 <CAMQGjvmTdxyXHcaYZTmbLYk-HwcLV+E9iv-bTABMBZR6ghvr2Q@mail.gmail.com>
To: solr-user@lucene.apache.org

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=E7ois


On Nov 1, 2011, at 7:46 AM, arshad ansari wrote:

> Hi,
>=20
> Is SQL Like operator feature available in Apache Solr Just like we =
have it
> in SQL.
>=20
> SQL example below -
>=20
> *Select * from Employee where employee_name like '%Solr%'*
>=20
> If not is it a Bug with Solr. If this feature available, please tell =
the
> examples available.
>=20
> Thanks!
>=20
> --=20
> Best Regards,
> Arshad