Re: Use SOLR like the "MySQL LIKE"

On Tue, 18 Nov 2008 14:26:02 +0100 "Aleksander M. Stensby" <[EMAIL PROTECTED]> wrote: > Well, then I suggest you index the field in two different ways if you want > both possible ways of searching. One, where you treat the entire name as > one token (in lowercase) (then you can search for aver

Re: Use SOLR like the "MySQL LIKE"

Ah, okay! Well, then I suggest you index the field in two different ways if you want both possible ways of searching. One, where you treat the entire name as one token (in lowercase) (then you can search for avera* and match on for instance "average joe" etc.) And then another field where yo

Re: Use SOLR like the "MySQL LIKE"

Thanks for the quick reply! It is supposed to work a little like the Google Suggest or field autocompletion. I know I mentioned email and userid, but the problem lies with the name field, because of the whitespaces in combination with the wildcard. I looked at the solr.WordDelimiterFilterFactor

Re: Use SOLR like the "MySQL LIKE"

Hi there, You should use LowerCaseTokenizerFactory as you point out yourself. As far as I know, the StandardTokenizer "recognizes email addresses and internet hostnames as one token". In your case, I guess you want an email, say "[EMAIL PROTECTED]" to be split into four tokens: average joe