you can index each of these field separately... field1-> Id field2-> name field3->user_id field4->country.....
.... field7-> landmark While quering you can specify "q=Landmark9" This will return you results.. And if you want only particular fields in output.. use the "fl" parameter in query... like http://localhost:8090/solr/select? indent=on&q=landmark9&fl=ID,user_id,country,landmark& This will give your desired solution.. On Wed, Jul 28, 2010 at 12:23 PM, Jonty Rhods <jonty.rh...@gmail.com> wrote: > Hi All, > > I am very new and learning solr. > > I have 10 column like following in table > > 1. id > 2. name > 3. user_id > 4. location > 5. country > 6. landmark1 > 7. landmark2 > 8. landmark3 > 9. landmark4 > 10. landmark5 > > when user search for landmark then I want to return only one landmark > which > match. Rest of the landmark should ingnored.. > expected result like following if user search by "landmark2".. > > 1. id > 2. name > 3. user_id > 4. location > 5. country > 7. landmark2 > > or if search by "landmark9" > > 1. id > 2. name > 3. user_id > 4. location > 5. country > 9. landmark9 > > > please help me to design the schema for this kind of requirement... > > thanks > with regards >