I have just compeleted a website for a client. Now they want a search button on the website for their customers to search the website.
The problem is all the data on the website comes of a SQL database, so there is dynamic data and some static data. I have heard of Freetext Search , but I am unsure about how poweful it is. When I display the search results I want the words searched to be highlighted too. I also want to search both the dynamic data and the static one.
What are the best techniques to implement this? Can someone please direct me to articles or links related to this problem. Appreciate all the help. Thanks
The problem is all the data on the website comes of a SQL database, so there is dynamic data and some static data. I have heard of Freetext Search , but I am unsure about how poweful it is. When I display the search results I want the words searched to be highlighted too. I also want to search both the dynamic data and the static one.
What are the best techniques to implement this? Can someone please direct me to articles or links related to this problem. Appreciate all the help. Thanks
