I am creating a website similar to yel where people add information about their businesses to show they are available for clients who need them. The business table has the following fields (business name, categories, products, description, phone, pictures, etc.).
The problem I am facing is how to bring the best results according to the user's "search query"? Against which field should I base? I am so interested about this problem since I have seen many websites have the following problem with the following scenario:
- A client searches for a business with a given category, however the categories used by the website have different name for the same category he wants, so no results even if the business he wants exist in the database.
Example: client searches for "computer programmer", however, computer programmers are tagged "developers".