I hope this question is not to general but I already googled it and I tried to find an answer in this forum:
I would like to have a search function on my site to find news articles. I want to use MySQL's MATCH AGAINST function because it seems to be the most advanced way to do that (pls correct me if i'm wrong here). Right now the user can type in a word and the page shows all articles that contain EXACTLY that word.
What I actually want to achieve is that the user is able to type in an incomplete word like for example "wiki" and MySQL does not only return articles that contain the word "wiki" but also articles that contain for example "wikipedia". (It's a German page and a feature of the German language is that you're able to construct composite words - this is why it is so important)
I would be glad for any help or links regarding this!!
Thanks a lot in advance!!