Here is what we do in SQL: mysql> select * from _tbl; +----+------------+ | id | field | +----+------------+ | 1 | plain text | | 2 | wil_c% | +----+------------+ 2 rows in set (0.14 sec)
mysql> SELECT * FROM _TBL WHERE 'wildcard' LIKE FIELD; +----+--------+ | id | field | +----+--------+ | 2 | wil_c% | +----+--------+ 1 row in set (0.12 sec) So the patterns are associated with the actual documents in the database. We use those fields as a means to manually customize some searches. Thanks, Alexander -----Ursprüngliche Nachricht----- Von: Jack Krupansky [mailto:j...@basetechnology.com] Gesendet: Freitag, 10. August 2012 18:39 An: solr-user@lucene.apache.org Betreff: Re: AW: Indexing wildcard patterns "Doc1 has the pattern "AB%CD%" associated with it (somehow?!)." You need to clarify what you mean by that. To be clear, Solr support for wildcards is a superset of the SQL LIKE operator, and the patterns used in the LIKE operator are NOT stored in the table data, but used at query time - same with Solr. In SQL you do not "associate" patterns with table data, but rather you query data using a pattern. Step back and describe the problem you are trying to solve rather than prematurely jumping into a proposed solution. So, if there is something you already do in SQL and now wish to do it in Solr, please tell us about it. -- Jack Krupansky -----Original Message----- From: Lochschmied, Alexander Sent: Friday, August 10, 2012 5:25 AM To: solr-user@lucene.apache.org Subject: AW: Indexing wildcard patterns I thought my question might be confusing... I know about Solr providing wildcards in queries, but my problem is different. I have those patterns associated with my searchable documents before any actual search is done. I need Solr to return the document which is associated with matching patterns. User does not enter the wildcard pattern; wildcard pattern must be tested by Solr automatically. So in the example I provided below, a user might enter " ABCDXYZ " and I need Solr to return Doc1, as Doc1 has the pattern "AB%CD%" associated with it (somehow?!). Thanks, Alexander -----Ursprüngliche Nachricht----- Von: Ahmet Arslan [mailto:iori...@yahoo.com] Gesendet: Freitag, 10. August 2012 10:34 An: solr-user@lucene.apache.org Betreff: Re: Indexing wildcard patterns --- On Fri, 8/10/12, Lochschmied, Alexander <alexander.lochschm...@vishay.com> wrote: > From: Lochschmied, Alexander <alexander.lochschm...@vishay.com> > Subject: Indexing wildcard patterns > To: "solr-user@lucene.apache.org" <solr-user@lucene.apache.org> > Date: Friday, August 10, 2012, 11:07 AM Coming from a SQL database > based search system, we already have a set of defined patterns > associated with our searchable documents. > > % matches no or any number of characters _ matches one character > > Example: > Doc 1: 'AB%CD', 'AB%CD%' > Doc 2: 'AB_CD' > ... > > Thus Doc 1 matches > ABXYZCD > ABCD > ABCDXYZ > ... > > Whereas Doc 2 matches only > ABXCD > ABYCD > ABZCD > ... > > This can be achieved in SQL WHERE statements using the LIKE operator. > > Is there a (similar) way to this in Solr? Yes, wildcard search in solr * matches no or any number of characters ? matches one character http://lucene.apache.org/core/3_6_0/queryparsersyntax.html#Wildcard%20Searches
