Thanks a lot Isan. That's helps. On Wed, Mar 23, 2016 at 1:59 AM Ishan Chattopadhyaya < [email protected]> wrote:
> Hi Sankara, > Please use the solr-users list for such questions; this list serves a > different purpose and your question could get lost here. > > Try to use a string field, instead of a text field, in your schema. You > would need to reindex your documents. > > https://cwiki.apache.org/confluence/display/solr/Field+Types+Included+with+Solr > > As an example, you could have a field col1_s (which is a dynamic string > field based on the out of the box schema). Alternatively, you could add a > string field to schema by the name of "col1": > <field name="col1" type="string" indexed="true" stored="true"/> > https://cwiki.apache.org/confluence/display/solr/Defining+Fields > > Regards, > Ishan > > > On Wed, Mar 23, 2016 at 10:33 AM, SHANKAR REDDY < > [email protected]> wrote: > >> Team, >> I have the below requirement using solr search with fq. >> >> We have table A, with column COL1 which has the below values. >> >> Table A >> Col1 >> -------- >> SANKARA REDDY TELUKUTLA >> SANKARA TELUKUTLA >> SANKARA >> >> The requirement is when we search using fq on COL1, for SANKARA, I would >> like get exact match like SANKARA but not other records. >> >> At this point, I see the fq=COL1='SANKARA' , which returns all the fields >> starts with SANKARA i.e all the records. But I want to get only SANKARA >> ( like exact match ). >> >> Please let me know how I can achieve this. >> >> >> Kind Regards, >> Sankara Telukutla >> MDM/ BIG DATA Solution Architech >> -- >> >> Kind Regards, >> Sankara Telukutla >> > > -- Kind Regards, Sankara Telukutla
