col2 like %aa%
Lucene doesn't handle queries where the start of the term is not known very efficiently.
Is it really able to handle them at all? I thought "*foo"-type queries were
not supported.
They are not supported by the QueryParser, but an API created WildcardQuery supports it.
I certainly do not recommend using prefix-style wildcard queries though, knowing what happens under the covers.
Erik
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]