Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2

Thread: In boolean mode

  1. #1
    Senior Coder timgolding's Avatar
    Join Date
    Aug 2006
    Location
    Southampton
    Posts
    1,517
    Thanks
    114
    Thanked 110 Times in 109 Posts

    In boolean mode

    Can anyone help me understand why
    Code:
    SELECT *
    FROM `SITES_RANGE`
    WHERE MATCH (
    NAME
    )
    AGAINST (
    '+sip +compressors'
    IN BOOLEAN
    MODE
    )
    returns exactly the same results as

    Code:
    SELECT *
    FROM `SITES_RANGE`
    WHERE MATCH (
    NAME
    )
    AGAINST (
    'sip compressors'
    )
    Im using mysql 4.1.
    I was hoping that the boolean mode search would only find results with both of the words in the match field. But its returning the same as the simple full text search. What am i doing wrong?
    You can not say you know how to do something, until you can teach it to someone else.

  • #2
    Senior Coder timgolding's Avatar
    Join Date
    Aug 2006
    Location
    Southampton
    Posts
    1,517
    Thanks
    114
    Thanked 110 Times in 109 Posts
    After much searching i found the answer.

    ft_min_word_len was set to 4 so the term +sip was being ignored as it is under 4 letters.

    The solution was

    to put
    [mysqld]
    ft_min_word_len=3

    into my.cnf and restart the mysql server then recreate my full text indexes.
    You can not say you know how to do something, until you can teach it to someone else.


  •  

    Posting Permissions

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