Hi Suren, You could try a textfield with a WordDelimiter filter + EdgeNGram filter (this latter only in the index analyzer). In this way your heading will be indexed as
Jo Joh John Johns .... Johnsonso Johnsonson Johnsonsons and a query for Johnson & so Will be translated into Johnsonso Therfore founding a match with one of the indexed tokens. Best, Andrea On 27 Dec 2013 20:03, "suren" <gutti_re...@yahoo.com> wrote: > My field type is text and i am using WhitespaceTokenizer. I want to search > like SQL like search > ie I want to search for ORGANIZATION_NAME field > ORGANIZATION_NAM:"JOHNSON & SO"* > > should return > "JOHNSON & SON", "JOHNSON & SONS", "JOHNSON & SONS COMPANY"... > > I tried > ORGANIZATION_NAM:"JOHNSON &" AND ORGANIZATION_NAM:SON* > Problem with this is It will bring "SWANK & SON, INC. C/O EVELYN JOHNSON". > I want the result to be like SQL like search. > > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/adding-wild-card-at-the-end-of-the-text-and-search-like-sql-like-search-tp4108399.html > Sent from the Solr - User mailing list archive at Nabble.com. >
