Thanks for the Info, I am getting all the results, but I need to get the exact match as the first row and after that the near by match. Something like relevance order.
-----Original Message----- From: Jack Krupansky [mailto:j...@basetechnology.com] Sent: Thursday, February 13, 2014 9:17 AM To: solr-user@lucene.apache.org Subject: Re: Multiple Column Condition with Relevance/Rank Use the OR operator between the specific clauses. -- Jack Krupansky -----Original Message----- From: EXTERNAL Taminidi Ravi (ETI, Automotive-Service-Solutions) Sent: Thursday, February 13, 2014 9:09 AM To: solr-user@lucene.apache.org Subject: Multiple Column Condition with Relevance/Rank Hello, Someone can help me on implementing the below query in Solr, I will using a rank in MS SQL and a return distinct Productid Select productid from products where SKU = "101" Select Productid from products where ManufactureSKU = "101" Select Productid from product where SKU Like "101%" Select Productid from Product where ManufactureSKU like "101%" Select Productid from product where Name Like "101%" Select Productid from Product where Description like '%101%" Is there any way in Solr can search the exact match,starts with and anywhere.. in single solr query
