Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

The database contains information about businesses : title,name, categories, services, description ...

to bring the relevant businesses to the user according to his search query I'm thinking about this solution :

  • If the query matches with a category I return all the businesses for that category.
  • Else, I use SQL Server's full text search with ranking option on : title,services, description columns to get relevant businesses.

Have you any better solution to suggest ?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.