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
add comment

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.