I am using solr successfully with asp.net however I have a new search I need to create based on a mediumtextfield in mysql. I need to search that entire field against the index.
Is there a best-practice approach for this? e.g. to select keywords from the mediumtext field first?
Thanks.
Sounds like you're going to have to remove common words to get a decent hit rate. You could use the StopWords functionality and a list like http://www.lextek.com/manuals/onix/stopwords1.html
Once this done then matter of picking a search strategy that you think will work best based on test data?
http://lucene.apache.org/core/2_9_4/queryparsersyntax.html#Wildcard
Good Luck :)