From the last few weeks I am working on a business listing site. In my problem, there are two tables business table (which contains the name and address descriptions etc) and keywords table (which will contain several keywords to define the business and each keywords will be separated by comma (,) ).
My question is that suppose a user search a data, which have the unknown business name, so in this case how can I show the result which is matching with the result. And also the most effective method to inquiry both tables when user drop in the business name and like Softtech Solution (business name) and PC support (watchword) and additionally presentation a business which could have the same name and likewise presentation alternate business which has the same magic words.
Bookmarks