SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    Founder of Primal Skill Ltd. feketegy's Avatar
    Join Date
    Aug 2006
    Posts
    482
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Boolean Search Help

    My question is how to set wildcards in fulltext boolean search?

    I have this query:
    Code:
    SELECT * FROM table1 WHERE MATCH(name) AGAINST ('smith' IN BOOLEAN MODE)
    I'd like to set the wildcards in the AGAINST part so if I search for smi or mit or mith or smit it will get the same result.

    I know about making this: AGAINST ('smith*' IN BOOLEAN MODE) but this will only search for smit or smith and I can't put * in front of the search word...

  2. #2
    Founder of Primal Skill Ltd. feketegy's Avatar
    Join Date
    Aug 2006
    Posts
    482
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wow.
    I think this basic stuff is not possible in MySQL...

  3. #3
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    that's not possible with full-text searching. you will have to use LIKE.
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  4. #4
    Founder of Primal Skill Ltd. feketegy's Avatar
    Join Date
    Aug 2006
    Posts
    482
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Then I think full text search s*cks bigtime...

  5. #5
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    you're asking full-text indexing to do something it's not designed to do. that's like asking your car to float you across a river. does that mean your car sucks, too?
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  6. #6
    Founder of Primal Skill Ltd. feketegy's Avatar
    Join Date
    Aug 2006
    Posts
    482
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by longneck View Post
    you're asking full-text indexing to do something it's not designed to do. that's like asking your car to float you across a river. does that mean your car sucks, too?
    OK, then what's the purpose of full-text searching if it's not searching? :sarcasm:

  7. #7
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    it's for searching complete words, not word fragments.
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast


Bookmarks

Posting Permissions

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