Partial word matching using FULLTEXT search?

Discussion in 'Databases' started by mhuggins, Jun 26, 2008.

  1. #1
    I am attempting to search through a FULLTEXT index using MATCH AGAINST, but I'm running into some trouble. I would like to essentially do a LIKE '%keyword%', such that keyword can be found as a whole word or part of another word.

    The closes thing I've found is to perform a MATCH AGAINST ('keyword*'), which matches the beginning of a word. However, I'd like to also find matches within a word, using something like MATCH AGAINST ('*keyword*'). It seems this isn't possible though, as it returns no results.

    Any suggestions?
     
    mhuggins, Jun 26, 2008 IP
  2. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #2
    Remove Reply
     
    Social.Network, Jun 26, 2008 IP
  3. mhuggins

    mhuggins Peon

    Messages:
    39
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    * bump *
     
    mhuggins, Jun 30, 2008 IP