If you're talking about queries rather than autosuggest, you really need to look over, say, Solr In Action. SQL stores the entire data string, thus there's no way to search for individual words unless you do the %word% thing.
Solr indexes _tokens_ individually, so (assuming you've used a tokenizing analysis chain, try text_en) you can just search on single words, e.g. loan and you'll get back your matches. Also, spend some time with the admin/analysis page to see the effects of various token chains. Best Erick On Fri, Apr 27, 2012 at 8:36 AM, Sohail Aboobaker <sabooba...@gmail.com> wrote: > I am new to Solr as well but based on what I have read so far, once you > have created index in Solr, you should look at ajax-solr. It provides a > good example to type ahead widget (show list as you type). > > Sohail
