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 ?