Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2010
    Posts
    6

    Unanswered: Search for an incomplete word

    Hey,
    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!!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by mynameishenning View Post
    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).
    that's probably what you want, why don't you try it

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •